Amnesia The Dark Descent, first time you see one of the monsters. Nothing comes close to that game. Like literally nothing.
Apart from two others. Silent Hill 2 - The motel. Whilst on the phone to my mate, I was in the motel in the room where you hear the whispering. I turned my PS2 off lol.
Or the scene in 'Scratches' where the 'thing' runs past the crack in the wall. Doubt many people have played Scratches though.
Resident Evil series doesn't really do it for scares, only a few moments in the original were ever truly 'scary'.