If you don't mind using mods, MCCC has a few options that suppress unwanted vampire interactions. Vampires can't turn sims involuntarily, so you won't be overrun with them like we were in TS3 supernatural.
Vampire lore skill is easy to level up through books, and if you put some garlic braids in your house, vamps won't be able to drink from your sims. Even if they do, it only gives a minor uncomfortable moodlet, so it isn't gamebreaking if one slips through before you get your garlic placed. Vampire break ins are rare in any case. The more annoying issue is that vampires will sometimes prevent Sims from leaving public lots.
As for value, that's subjective. To me, there isn't enough in the pack to justify its price without the vampire gameplay. If you like the gothic themed deco, your mileage may vary. I recommend doing the early tiers of the new aspirations, though. They are a relatively easy way to get some early game points. None of the aspirations can be completed by non-vamps, but some of the early objectives are available to normal sims.
One note though. The Vamp pack is buggy, and it may bring some issues into your game. Most of the gamebreakers have been fixed, but there are still a few unsquashed minor annoyances.