Love the game, but it didn't feel much like a Resident Evil game. Still awesome though, I own the original Gamecube version, as well as the Premium Edition PS2 version...heh.
No RE, especially 4 has ever scared me though.
(Though my favorite series of all time, Silent Hill can be pretty scary)