I made the mistake of watching the opening of Bioshock alone...
Took me at least 2 weeks to be able to pick it up again.
I get scared real easily :P

Oh and Resident Evil

Resident Evil 2, when I was playing the 2nd story.

There's a point where the Nemesis thing comes at you after solving a puzzle involving a chalk board; you stop it, good, done, solve puzzle.

Then, running down the corridor to get to the next room, BOOM right through the fucking wall at me.

Got outta there something fierce.

EvilEngineNumberNine:

But Fatal Frame 2 is the only game that ever made me turn on the lights. Just that blaring static growl when a ghost is near you, and the frantic but purposefully slow panning of the camera as you search for the ghost you know could be attacking you any second. And finally the image of your grisly attacker fades into view, the horrifying visage inches away from your lens and howling for your blood as you reflexively smash the shutter button and barely prevent your soul from being shredded by this demonic creature. You catch your breath and glance at the grizzly image left behind on the camera. Take a few steps forward into a strange room and...
hhhiiiiiiissssssssssssssssssgrowwwwWWWWWWWWWWWWWWWWWWWWWWWWWLLLLLLLLLL!L!LLLLL!!!LLLLL!!!

Just reading that at 8 AM has freaked me out.
Flashback...8-(

Half-Life 2 managed to scare me into turning the console off and not turning it on again for a week.

Fuck headcrab zombies.

Penumbra: Overture was one game that was really a huge mind-fuck. The beginning of the game is really scary.

And yeah STALKER when you were crawling in the undergrounds.

Eternal Darkness. That game really freaked me out at times.

one moment in shadow of Chernobyl, when your in a underground tunnel, and you run into a massive giant pig thing, and in your hurry to escape, you tun off your flashlight, and when you turn the bloody thing back on, 2 massive giants are standing in front of you........

and the "harmless companion cube" off Garry's Mod.

The level in Condemned 2 where you've gotta escape that place with that other dude. But listen when he says his name, then you both see that other dude die, listen to his name. Then after that, the dude who you're escaping with dies. Then you find out it's just Ethan dreaming or something. But, go down to see that guy with the suit when Rosa tells ya too, when you go in the elevator, look at the note on the wall. It's a memorial for the guys that died in Ethan's dream.

survival horrors like Haunting grounds and clock tower, now those are scary.
To get the full effect play alone and turn off your lights, but even if you got friends with you it's still piss scary.
For Haunting grounds all you got is a dog that growls when someone might be coming around,
and with the multiple endings depending hwo you trap or accidently kill your persuers or how well you treat your dog.
Have ending is when you kick the crap otu of the dog so it hates you and you end up raped, pregnant and go insane

I've played through both Condemned and Condemned 2, the only parts that were remotly creepy invovled mannaquins. other than that, the games felt like they were trying so hard to be scary it just wasn't. I've never tried so hard to get drawn into the atmosphere and failed at it. Plus the cutscene animation style, I dunno...it felt cartoony.

I don't really play horrors but rule of the rose was pretty creepy

ThaBenMan:
Hopefully, it will be Dead Space.

I second that.

I'd have to go with Rule of Rose on the PS2. It's not so much a shocking game as it is a creepy psychological thriller. That makes it way more ominous in my books. There's just something about playing a defenseless little girl in a creepy run down city of lost children world that's every so wrong.

As for the pure terror you get from scary ass things jumping out of nowhere, I'd have to with Obscure 2, 'cuz as much as RE2 did that to me, its camera and lighting was a lot more forgiving than Obscure's, which just freaked me out incessantly.

umm, i think silent hill, but i dont know whether is was 1 or 2 O_o, twas probably the atmosphere and sounds that scared me

sadly i think my mums is tomb raider XD because she always "needs the toilet" before a boss fight, fun to watch though

Condemned: Criminal Origins. There were a lot of scary parts, including the very end sceno when he's standing in the bathroom, but the scariest part was easily in the abandoned school when the supposedly dead guy in the locker grabs you while you're taking a picture. I made the mistake of playing that alone, in my basement, at 1:00 in the morning. Nearly messed my pants.

Condemned was great and I'm really glad I picked it up a couple of months ago out of curiosity. Mostly predictable except for those damned mannequins. And after I made a point of shooting every single one in the store with the tazer because I just knew they would do SOMETHING it still scared the crap out of me. Your first instinct is to run away but they keep following you until your only option is to stay in the room with them or jump into the unknown. A really great and chilling moment.