I had that same experience especially when I got to the end of the game because of the way the plot twisted into insanity.Asymptote Angel said:Silent Hill 2 was pretty scary. 4, not so much.
Easily the scariest game I've ever played, however, is Condemned 1 (haven't played 2). It was sooooooooooooo atmospheric--I've never had a game get in my head like Condemned did. The frantic-ness of the combat and the sinister-ness of the plot fit in brilliantly. Everything about that game was so intense... every moment was almost overwhelming.
...and that sense of being overwhelmed is how to truly scare someone. Silent Hill was scary on a psychological level, but Condemned was scary on a physical andpsychological level. Every moment has you on the breaking point, and the slightest things will make you piss yourself. Terrifying.