Stupid scenes and such would be good for a game with no purpose whatsoever except to kill millions of zombies in various ways. So instead of naming off things that are wrong with it or might not have been great choices, just enjoy what there is.
Well the swat zombies look like they might be able to take a hit or two, also considering the new special infected such as the jockey.
Also they can't make the game too hard (i.e zombies are hard to kill) because then it would be almost impossible considering the amount of infected/special infected at one time.
As for scary, I must agree with you, it isn't very scary.