First game that scared me must have been Barbarian (c64) at a friend's place.
And then, the mummy on the first level of Dungeon Master. Walking around for a while and everything is calm and silent. Then you open that door and a hissing mummy comes out right before your eyes. Easy scared I was.