No, it's stupid, and the penalties outweigh the bonuses. Yay, you get a lame Absorb Health spell (less than half as powerful than Flames) bonuses to Sneak, and Illusion which are OP enough without them, and all you have to do is avoid daylight, or you can't heal, and that's before your condition progresses to the point that you are an attack on sight pariah, and have to feed to regain what's left of your humanity? Sign me up! Oh wait, that's bad!
If you like, become a werewolf, you don't get Resting bonuses, and are slightly weak against one of the rarest weapon types in the game only when in Beast Form. In return, you're immune to disease (Including Vampirism, which has an annoying habit of lowering your Health) and can turn into a melee masher, not to mention opening up 5 of the best follower/trainers in the vanilla game, the best forge, steel, lightest Heavy Armor, and a whole bunch of Radiant Quests that go on forever.
Or, you can suck.