Prey and the Dishonored series are up there, for experiences of that sort. Go in blind to Prey if you can.

Though I played those on PC, not PlayStation.