It's mostly just annoying. Very few enemy types, enemies infinitely respawn and they level with you, weapon durability is low and ammo carry capacity is laughable. Act II is decently suspenseful because you're in narrow streets engaging groupings, and there's one area that's terrifying, but overall the game's pretty mediocre.
Danse De Raven
"P&N: Not Quite as Bad as Stormfront"