I actually find this to be one of the more interesting questions for the Dragonborn to choose between. On one hand, you have the Dawnguard who are a bunch of religious militants the incredible bigots of the Vigilants see as too extreme. On the other, you have a race of eternal immortals who just happen to be headed by a psychopath.
Which is the best side to go with?
Traditionally, vampires get the short end of the stick in this but the undead in Tamriel are not necessarily evil. Likewise, as head of the coven, the Dohvakiim has the potential to be a far better Vampire Father than any other. His immortality could also serve as an excellent guide to future generations of Skyrim.
Plus, as we see with Solitude's court wizard, some vampires are very productive members of society.