Haven't played it, people says it's really good.
But as zeropunctuation says, there are three types of horror games
1. The ones where you are in a dark hallway and a guy jumps out and says "aboogywoogywoo!" (Doom 3)
2. The ones where there is a guy standing behind you and you know he is going to say "aboogywoogywoo" but you don't know when and the tension begins to kill you (silent hill 2)
3. The ones where you are on a lightly lit hallway and an enemy shouts "aboogywoogywoo" really far away (Dead Space)
so hmm,
What do you think of Amnesia: The Dark Descent