One thing most of you fail to point out. That we became "hardened" or "used" to a lot of this stuff. The good old games that use to scare the crap out of me no longer do so (same with movies). The only thing I get now is the shock (like Slender Man showing up in the bath house, or the zombie in the tub RE1). The only good game Iv played from a "big" studio was Condemned 1&2 bit on the creepy/disturbing side and its resident evil lack of ammo made it the only console game close to Survival Horror.
On another note in this department the last game that really gave me a good chill down my spine (only once and your not going to like the name of the game) was CoD:MW2 when you emerge out of a bunker, I think, to see the Russians dropping in full force. That however is scary for another reason.