The way I figure it, the majority of vampires you meet are evil because they active chose to not get themselves cured, for the most part. Sure, there are those that didn't get cured in time and became full fledged vampires, and you hear about them looking for other ways to cure themselves (the ones around Clavicus Vile's shrine for example, they asked him to be cured, so his answer was to let the Dragonborn kill them all, because Vile is a dike).
A handful seem to just use their vampirism to benefit others, like Serana and Janus Hassildor. So yeah, vampires can be good, it's just that most of em are evil because they were bad people to begin with.