Yeah, vampires have been pretty well nerfed in Skyrim. Though they are the only ones with access to an Absorb Health spell (not the enchantment), it's weak, and it's a massive mana drain. There are perks for being an underfed vampire, but then you have no way of interacting with the citizens of Skyrim without being shunned or attacked. It ought to be the other way around: you should get perks for remaining well-fed, instead of depriving yourself of humanoid blood. It would be fun to see a connection between vampires and a guild, but I can't see that being decent without be shoehorned in. It would be fun to have a secret cabal of relatively benign vampires within the College of Winterhold, instead of vampires being affiliated by default to the thieves and assassins.
Another fun idea would be to have the vampires struggling to create a connection between them and Molag Bal, the original creator of the first vampires. That could be a fun questline, or even a potential guild to join, although it would be yet another sneaky thief/killer guild. Vampires unfortunately do not hold a candle to the awesomeness of the werewolves, and it's a shame, because it used to be fun to roleplay a vampire. Now it's more like a chore.
