Eternal Darkness: Sanity's Requiem was a great game.

Resident Evil 4 was pretty good too.

as the best Horror games that i enjoyed?

Alone in the dark , Siren and Dino Crisis.

as the game that creeps the hell out of me?

Fatal Frame and Silent Hill.... oh and earthbound

I'm surprised more people haven't said the Clock Tower franchise. Those games are terrifying!

Resident evil (excluding 4 +5)
Clock Tower 3
Silent Hill 1-3

Resident Evil 0, Resident Evil 4 and now Dead Space: Extraction

Condemned 1 & 2 counting only the current generation.

Also, Demons Souls if your definition of scary is shitting your pants with fear.

you mean hide and seek franchise?

these games are all about the sudden jump ,  third one is actually very funny too.

Fate/Stay Night (especially the Heaven's Feel route) and Tsukihime (pretty much all the routes, except the Hisui route is pretty fucking creepy and more psychological... since you don't really move around too often).

I think the best horror is unintended ones though. Like the times you run completely out of ammo (or barely any), no health, and you're either being chased by a shit load of enemies, trying to stealth your way out of a huge fortification, or best, you're in the middle of a desolate dungeon with corpses everywhere, and now you KNOW there's a few more threats, but you just don't know where.

BioShock on normal (gonna try Hard, then Survivalist, which I'm really anticipating) kinda has the mood killed by the respawning enemies (I think it's bad. NIGHTMARE mode in DooM is not only too hard for me *laugh*, but makes it feel more like an fast action game. A horror game should be slow, even if slow is easier than trying to rush through a level in NIGHTMARE) and the action oriented gameplay.

Good horror is:

Stealth Gameplay.

Limited Ammo

Psychological (no bullshit screamers/pop ups like in the Grudge movie, or as I hear it, DooM 3. The fear should be generated by both you, and the feeling should be of disgust and taboo. Uncanny valley, having small weirdness, etc. It's the feeling of everything being normal, EXCEPT for a little something.)

Being weaker than the enemy

Creativity based (you can create traps, or use anything)

Open ended maps


EXTRA:

Having no humans, but a few occasional ones. (Going completely monster makes it predictable, but having too many humans kills the "something's wrong" feeling. Perfect example is the underwater sea levels in Deus Ex).

1. F.E.A.R
2. Bioshock
3. Resident Evil ermm 3.....i think
4. Left 4 Dead
5. Dead Space

1. Eternal Darkness - Sequel is NEEDED!!!
2. Resident Evil Remake
3. Silent Hill 3
4. Fatal Frame
5. Tingle's Rosy Rupeeland (that man is scary)

I almost forgot to take a cheap shot at Lair. God, that game was so bad I was to scared to even look at a console for a week.