I honestly never found RE that scary. They had jump moments, but there are differences between jump moments and pure terror. I will admit that RE 1/2 were a bit more frightening than any later game in the series (Code Veronica gets close for me, but 4 absolutely did away with trying to be creepy after the first level).
Manhut had a great way of building up suspense, but the final level utterly ruined it. Just replace the stealth with pure action; that's not horror, that's an action game.
LSD:DE was creepy, and that's it. However, LSD does its job all too well and creates a memorable sort of "what the fuck did I just play?" experience.
Eternal Darkness is fucking terrifying if you know nothing of what's going on. Once you know about how the sanity metre works, though, you'll be wanting to fuck around with it to see what else could have happened.