Back when Resident Evil came out on PS1, I was about 11 and a total chciken shit.
When my brother and cousins were playing it, it scared me so much that I went and jumped into my parent's bed and covered my head, with the covers so I couldn't hear it, in the next room.
As for modern games. The Suffering is pretty creepy, but I like horror games now, as I'm a horror fan.