Resident Evil 2 scared the crap out of me after a while. The first time i played it, my friends were all like "Seriously that game will scare the sh*t out of you" and i was like "Video games aren't scary, how can a video game possibly scare you??"- famous last words.
I did complete RE2, but it was weird, the more i played it the scarier it got- it wasn't one of those zombie packed shooting games (it still had a fair amount of zombies and other freakish creatures though). The thing was though is that a lot of the time you wouldn't know when to expect zombies, you kinda expected them to be in every room, but then you'd walk into the room and there would only be a chilling silence. So you'd sigh a sigh of relief and would explore the room looking for ammo and possible keys or guns etc, and then leave the room. Not until you came back much later in the seemingly ordinary room would zombies come crashing through a one-way mirror and scare the crap out of you! The game was always leading you into a false sense of security like that, only to scare the sh*t out of you.
I hated the dark rooms and corridors as well, when you could hear things moving in the darkness but couldn't see them.
The coolest thing in the game though was the giant crocodile (a lot of people didn't discover this creature though) in part of the sewers, you would accidentally disturb it and it would chase you down the sewer halls; the best way to kill it would be to knock some gas cannisters as you ran like crazy from it- the giant croc would stop to pick up one of the gas cannisters in its mouth and when it did you turned around and shot the cannister making the croc's head explode! Mwahaha...
The best thing about the early Resident Evil games was the plot, but i think they milked the plot too much over the course of too many games (which is why i lost interest in the series eventually). I was never much of a horror game fan, however resident evil was just too good not to play it, however i have to admit that it did give me quite a few scares and didn't do much to improve my fear of the dark etc.