It seems like vampires have a whole lot of bugs. For me, I have a former vampire who died to the sun, when I was able to add her to the household again by getting the friendship bar up and asking her to move in, she would have 1.6k vampire skill points (while my other vampire is stuck at nearly a full bar and can't gain any more points). I then let said other vampire mix the healing drink, which the ghost vampire drank. She turned human again, and would get the old human needs back aswell as having skills like the bat or teleportation and weaknesses like the one where she can only sleep in coffins removed. I later quit the game and when I started playing again I noticed her having a +10 "Okay"-moodlet that overrides all other moodlets, and which is caused by the associated vampire skill. Removing the moodlet/resetting all moodlets with commands works, until I save the game and reload. Just now I noticed her being sick and vomiting, even though the food she ate was perfectly fine, and she still seems to have the Withered Stomach weakness active.
This adds ontop of the other issues I am having with vampires. It doesn't matter whether I play with or without mods, swap saves around, reset all Sims using mods or commands or do a Waltz. Currently I am trying a completely new save with a newly created vampire. Let's see whether I get those bugs again.
Edit: so I got the Sim up to the Max. Vampire stage eventually, and now he is stuck with a nearly full bar, unable to get any more points past 48, so this whole "being able to still gain points without having to accept any more weaknesses" doesn't really work. I did not use any mods at all, it seems that either vampires themselves are bugged or that there are other packs it conflicts with.