I too recommend Vampires Can Kill by Zero. I also use vampireinvasionfix by lotharihoe (sharing a link since it's part of a compilation and a working link can be a bit hard to find with Google search: https://www.patreon.com/posts/43781779 ). Makes vampire invasions far more frequent since they must have like a 0,1% chance to happen. I personally haven't had a single one before installing this mod. Combining it with the potentially deadly nighttime drinks module from Vampires Can Kill, actually makes vampire break-ins pretty scary. Have had 2 of my own sims die because of it.