Wow, that is brilliant lol xD I've always heard of condemned being utterly terrifying, aswell as fatal frameae86gamer said:Fatal Frame 1, 2, 3, and Condemned.
This scene is from the Condemned game.
My suggestion, is Doom 3. Don't let anyone tell you you can get through it run and gun style with loud as fuck music playing to lessen the impact... I did that most of the time through the game and it still generally scared the fuck out of me. Not just startled, actually scared me; few games have managed to do that, in fact, I don't think I've ever played a game that's scared me as much as Doom 3. It's very very immersive, that's probably the reason.