I can only recall 2 moments where i've actually been scared by a game.
First one was when i was 9, playing Ocarina of Time, after you've found the Master Sword and went forward in time into adulthood, going out into the marketplace and finding those god damn zombies walking around, they scared the shit out of me, the noises they make are really creepy as well.
Second one was back when Doom 3 had just been released, and i played it in a completely dark room with the newest brand of headset (with vibrations), having almost surroundsound and sitting in a dark room was a bad combination for the first playthrough, i only played for about an hour but that scared the crap out of me.
First one was when i was 9, playing Ocarina of Time, after you've found the Master Sword and went forward in time into adulthood, going out into the marketplace and finding those god damn zombies walking around, they scared the shit out of me, the noises they make are really creepy as well.
Second one was back when Doom 3 had just been released, and i played it in a completely dark room with the newest brand of headset (with vibrations), having almost surroundsound and sitting in a dark room was a bad combination for the first playthrough, i only played for about an hour but that scared the crap out of me.