have you tried limbo.... Its a damn small game but excels in graphics and limited controls.... If you need more list ...just list the games you have played.... So that we may get an idea on what games you have played... Cheers
Would be much better to not watch the movie. While it's "good" (compared to other game-move tie-ins) it still doesn't justice to the game... Play the games first, then you can watch it. Also: amnesia the dark descent
The series Alone in the Dark (especially the 4th one) are amazing. You can also try Resident Evil or even Dino Crisis to some extent.
The first 2 of the Silent Hill series and Silent Hill Downpour is great!! Turn off all the lights would help make it scary. Also heard that Slender Man is a scary game. I've watched a bit of the game play on YouTube and just got really creepy feeling from it.
Resident Evil is a great Horror Game. I just downloaded RE6 for XBox 360 (the demo) and it is pretty good. Graphics are nice. Cheers, Ron