Astin said:
I always thought the nightmare scenes in max payne with the baby crying and blood trail real creepy.
Thats just disturbing... not really frightening.
AS far as things that have made me get up and leave the game/computer.
WAY back when survival horror was just getting its foothold in the gaming industry... Resident Evil 1 and 2 were out. Silent Hill was JUST around the corner... and since everyone know Dinosaurs are fucking scary... Capcom decides to release Dino Crisis.
Overall... the game itself isnt scary and Im sure if I were to go back and play it... I wouldnt think it was frightening... but I was 12... Surv.Horror was relatively new. And the scene when you get into the Administrators Office... and OUT OF FUCKING NOWHERE... BAM T-rex breaks his face into the office plateglass window. In retrospect... I have since learned, that "Large plate glass windows that arent broken are about to be in an attempt to make me shit my pants" http://www.youtube.com/watch?v=Dp-59rTKNi4
That has the largest "holy shit" moment for me.
Another close one, was in Silent Hill3, when you are going through the amusement park, and you are in the Borely Haunted Mansion (Skipto 3:25) http://www.youtube.com/watch?v=dPOpkif0SDk&feature=related
Now, if inducing a heart attack is the same effect. F.E.A.R. did a decent job of making me waste ammo on absolutely nothing. F.E.A.R.2

roject Origin upgraded that when the phantoms WERE LIKE WHISPS OF AIR AND LOOKED PISSED!.
http://www.youtube.com/watch?v=_Vib42kWkd8 (phantoms from FEAR2)
I have not played through Condemned: Criminal Origins but I hear thats one hell of a horror game. Ive got it in my GameFolder just should install it and play it.
And... as far as just the most unerring scene ever. When you get to the first set of apartments in Silent Hill2. You come to a barred hallway. And farther down the hallway, you can see something. Its just standing there, swaying back and forth. And later on you have to go back up to it... and its gone. It hit me later... PYRAMID HEAD WAS RIGHT THE FUCK THERE!