I honestly never like the RE series too much. The only one that ever appealed to me was RE2 for some reason. I think it is a fun game, but I have never actually beaten it, I always grow tired of quickly. Which is odd because I grew up loving my long winded adventure games. Though I must admit, RE2 had some shit-your-pants-freaky moments.
RE4 on the other hand is one of the most enjoyable games I have ever played, it had a few scary moment, but you are right, nothing like RE 1 or 2. Heh, scariest moment in RE4 for me was when something jumped out of nowhere at me in the game, and at the EXACT same moment a misquito unexpectedly flew up my nose. This was sometime around 1 am, and I was playing in complete darkness. I had to pause the game and take a few minutes to catch my breath it scared me so badly.
Glad you got to play the demo of RE5. It is a lot like RE4, which I think is a good thing. I am afraid if you are a big fan of the old adventure game style Resident Evils, your days are up. I hate when franchise like that completely adandon their roots, I sympathize with you. Have you played Resident Evil 0 or the remake of Resident Evil 1 on the GameCube? If you really liked the older RE games, it is worth going down to gamestop and picking up a used $29.99 GameCube just to play those two games. RE0 is a whole new game taking place before the first one, and the remake has plenty of changes from the original making it worth the time of people who have beaten the old one countless times.