This is my opinion as well I appreciate both weakness to the sun even as a vampire in skyrim I don't go out in the sun when I want to explore or do quests the only time I go out in the sun is to sell my loot even if you don't burn to a crisp in the sun the -100% regen on magicka, hp and stamina is annoying.
A necessary inconvenience, Vampires do need their weaknesses because it is as much a curse as it is a gift. The only problem I still have with vampires is the lack of vampire strength and speed. I would also like to have the bat-like faces that npc vampires have.
This is what could have been done or could still be done.
Pros.
Vampiric Strength = X unarmed damage, X one/two-handed damage with X amount of chance to stagger or knockdown opponent. (gets higher the more you feed, stage four the limit though)
Vampiric Agility = Sprinting is faster, stamina drains slower at night, Jump height and length is increased.
Vampiric frost breath.
Mist form for human form.
Cons. In addition to current weaknesses.
Weakness while in a temple.(same as sun effect)
Unable to use silver or blessed weapons.(turn undead enchantments)
Unable to get blessings from shrines.
Only get well rested benefits through use of the coffin.
Need to feed to keep up benefits. (proper vampire feeding, not this reverse [censored])