I liked FEAR and Amnesia, but I'm pretty disappointed that FEAR3 crashes anytime it tried to go to cut-scene. I blame the game being made for those damn consoles first and the superior platform (computers) second. FEAR 1 was better than FEAR 2 in my mind, maybe because of the novelty of the game's horror mechanics.
Amnesia did a great job of making you run and hide, and the confusing feeling in dreams where you're running through the dark everything is hard to see. Try going through the game with no candles too.
One of the scarier moments in a game happened in DOOM 3, but not because the developers planned it. Generally, DOOM 3 had pretty lame and predictable action, but on one occasion there was a lighting bug where for some reason the entire area was completely black and the flashlight didn't work at all. It wasn't one of those sections where it wasn't supposed to work, because it still turned on, but the lighting on the surfaces didn't work. So I had to scramble around trying to make it to some light source in the distance all the while hearing all these weird noises and fearing I would be attacked. The same feeling occurs a bit in Amnesia, so that's a pretty good effect.
I tried playing Condemned Criminal Origins, but the fact that it was made for 4:3 screens and doesn't change the field of view for wide screens gives me slight motion sickness (the same way with HL2) which I don't enjoy.