I got Vampires as soon as it came out for the bb mostly (I love Victorian) and some of the CAS. Vampires are not my thing but thought the pack worth the risk. I can assure you that things have been toned down enormously. Some things I remember:
Break-ins virtually a nightly occurrence, even if not all household sims asleep
A vampire household member could do nothing to ward off the attack
Most attacks were by townie vampires, and nearly all of them had the power that made locked doors useless
80-90% of the time I had a sim on a community lot at night they couldn't go home until a break-in at an undisclosed location had completed
The only sure defense was the instant vampire cheat, though a garlic farm by the main entry was a big help
Status now:
break in attempts almost never happen, if they do it is by one of the pre-mades, usually Caleb or Vlad, & they can't pass through a locked door
Vlad's 'lovely neck' message for new sims almost never happens
can't remember the last time I found a townie vampire
no issues at all going home at night, whatever triggered the lock-out above is gone
locked doors have been an adequate if seldom needed defense, garlic farms primarily for the income, though sick vampires are amusing