I want to know what non-horror games (games not meant to scare) have scared you before.
For me I was always freaked out by Tomb Raider on the PlayStation.
Just walking through a tomb, no music playing, just the sound effects, suddenly some quiet-ish battle music starts playing and boom, out of nowhere I'm attacked by wolves.
I never got past the first area because of that.
A close second is the point in Final Fantasy 7 where Jenova escapes within Shinra Co. and that horrible music plays while you follow a trail of blood.