A game has never scared me such that I won't continue, but I think games have shown that due to the interactive nature they can probably exceed films in certain ways in this genre - i.e. you have to chose to walk down the dark hallway rather than sit and watch someone else do it.
Certain games have, however, produced the two main aspects of horror material for me, which is tension and unease/dread, and they are:
For tension : Alien vs Predator 2 (playing as Marine), Thief 3 (Cradle levels) and Fear
For unease / dread : Any Silent Hill game and Condemned
RE and similar games just don't do it for me at all. They have jumps and are fun, but there is no tension/dread for me at all as I just don't buy the scenario I guess...
Try to be reasonable... its easier than you think...
