Like literal scare?
When I was about 15 years old, I was at my cousins house and I tried playing a game called Police Quest: S.W.A.T. (Sierra), and I remember being terrified by it like it was some kind of horror game. It has such a weird creepy vibe and creepy ambience and creepy music and some of the scenes can scar a kids mind. I quit playing after getting freaked out and then was too scared to ever play it again. I have since then watched a complete play through of the game and it is still in fact a creepy game that is probably not for kids.
In the early 90s, so even younger than 15, I rented an SNES game called Drakkhen. Some of the scariest moments in that game for me where when it got dark out while you were walking around on the overworld, sometimes the stars would start moving in the sky and a scary giant monster would attack you. That sound when the stars moved was very creepy and startling like an alarm. It wasn't so much as the monster attack, but more that damn stars moving alarm sound that freaked me out.
Also there is a Castle (I think it's like the 2nd castle of the game) that has a shark in the moat and when you cross the bridge at the wrong time, the shark eats your character. I assume the game is running at like 30 fps, but the shark kills you in like 2 frames (almost impossible to see unless you are really paying attention) and it's so fast and the sound of your character dying is extremely startling. If you didn't know beforehand, you would just hold the up button on your controller to cross the bridge and all of your characters would be eating one after another in like 2 seconds.
Doom 2 used to give me nightmares when I tried to play it as a kid. Took me well until adulthood to finally play through the whole game.
Like it or leave it. Hey, where are you going?