Okay, I have to LOL at any Zelda references here... Not scary, ever. Play a few games.
We se a ton of Silent Hill and RE references here... Personally, I found SH freaky as shit until I saw the villagers rush at me in RE4. That is definitely a freaky motherfucking experience.
Both RE and SH have HUGE freaky moments,
But have you ever been scared shitless? My vote goes for AvP1 and trying to fight as a marine in the "crossroads hallway". When that radar lights up, you shit your pants.
Scariest? Maybe not. Most terrifying? Absolutely.
Or check out my new webcomic: http://selfcentent.com/