vampires are the monster of magic, if anything should get tweaked for melee it is werewolves, they are the monsters of might but they are borderline useless due to poor (read: no) leveling of the werewolf form
There are different vamps with different specialties in almost all types of vamp lore. Even in TES games.
Oblivion for example
http://www.uesp.net/wiki/Oblivion:Skills that gain a bonus:
- http://www.uesp.net/wiki/Oblivion:Acrobatics
- http://www.uesp.net/wiki/Oblivion:Athletics
- http://www.uesp.net/wiki/Oblivion:Destruction
- http://www.uesp.net/wiki/Oblivion:Hand_to_Hand
- http://www.uesp.net/wiki/Oblivion:Illusion
- http://www.uesp.net/wiki/Oblivion:Mysticism
- http://www.uesp.net/wiki/Oblivion:Sneak
http://www.uesp.net/wiki/Oblivion:Attributes that gain a bonus:
- http://www.uesp.net/wiki/Oblivion:Strength
- http://www.uesp.net/wiki/Oblivion:Willpower
- http://www.uesp.net/wiki/Oblivion:Speed
Of course the removal of skills and stats in Skyrim is a primary reason for this huge nerf of Vamps. Since we obviously are not going to get stats and skills back, they could at least create some new perks to buff up Melee toons. Otherwise, people who go Vamp will likely do the cookie cutter build, otherwise you intentionally self gimp.