Legacy of Kain for me. Fast, superstrong, telekinesis, excellent combat expertise thanks to millennium-long lifespans, night-immortality and several other vampire traits, like mist/bat transformation, mind control...
Also obvious weaknesses - holy artifacts deal huge damage, repel them if used on inanimate objects like walls or armors, can't stand still water (but rain doesn't harm) and of course, sunlight is bad. Like, very lethal.
But you do get to wield unbelievably powerful magical powers, swords that drain blood and you are hundreds of years old while looking beefed up.