The most memorable opening credits I remember seeing was from Werner Herzog's Nosferatu: The Vampyre (Nosferatu: Phantom der Nacht, West Germany 1979). I wouldn't say I was scared, as I wasn't. I can imagine some people could be.
The credits feature mummies (children, men, women, young and old) lined up in front of a wall, with spooky music playing in the background. The first time I saw it, I wondered how the makers managed to get their mummies look so realistic. Later I found out that the mummies were actually real, from a mummy museum in Mexico.
Actually the credits are available in YouTube. Just search for nosferatu-herzog opening credits, and it should be the first one on the list. I wouldn't recommend it for children or sensitive people, though, for a good reason, and thus I'm not posting a direct link.
_________________
I don't do signatures.