You cant compare L4D with RE series...
I played a bit of the demo at a friends and its a lot of fun. Its still as scary, more so than RE4 but less then the others. Best part is when you try to aim and your like "die!" then they run at you and you just freak out.