First game that scared me:

DOOM

I was playing late at night with all the lights off.

Some Cacodemon popped out of nowhere and scared the hell out of me.

Also, System Shock freaks me out, but more in a slow mindfuck sort of way.