Vampire is good, but the only bad thing is having to maintain it. Being vulnerable to fire is bad, unless you're a Dark Elf, which is the only bad thing, including not being able to regen hp, magicka and stamina in sunlight. And you also need to keep feeding once every three days.
So, personally...