Only certain moments of RE were scary. Once your first playhrough is done it's not as suspenseful anymore if you master the game and know what to expect.
I say RE is at it's scariest if it's a blind playthrough with no guides. After playing REmake for the first time I certainly didn't expect half the things that nearly obstructed me to progress.
(Such as the hanging man in the dormitories who committed suicide, cutting himself down and already being a Crimson Head after I re-entered the room upon Neptune's defeat by accident as Jill. Goddamn it, that made me jump out my socks. -___- )
"I'm the man you love to hate and I'm sure as hell not phased by you fakes." PSN: LatinChris_9990
I found RE2 genuinely creepy. I was nervous around every bend. When I played the B scenario, Mr. X just gave me the biggest heart attack. Also, the interrogation room licker nearly killed me IRL. True story, my brother was watching me play, I had the volume turned down really low, when it came out, he jumped really hard.
REmake was the only other game to give me a similar feeling but to a lesser degree since I knew what to expect. RE3 was more of me wondering when Nemesis was going to pop up. Not quiet as memorable as the initial two I mentioned.
The newer games are simply fun to play, but not at all scary.
Nemesis was scary (the monster itself) I didn't really find much else scary. Creepy sure...never really scary like a Fatal Frame or Silent Hill game though where I just wanted to turn the game off because it was too much. They had a whole lot more atmosphere too them than the newer games in the series though.