It all depends on the type of vampire and from what mythos. Vampire: the Requiem's Kindred are my personal favorite brand of walking dead- make me a Toreador Daeva, and I'll be walking around as an immortal panty-evaporating superman for however long I would deal with it. The blood you drain from humans apparently tastes like ambrosia and nectar to the undead, and the actual bite and draining is apparently better than sex for all parties involved. Plus you wouldn't need to kill your victims- seduce, fuck all night (these vampires can have sex by effort of will, even without pulses), and top the evening off with a super happy fun time kiss so you can take what you need. If they aren't still woozy from the best night of their life, chances are they'll call you back next day. Best part? The amazing method they sire other vampires. You have to drain a person to the point of death and willingly, actively feed them some of your own blood before they kick it- you can't drain a mass murderer and wake up three nights late only to find that the bastard us an immortal creature of the night unless you wanted to.
That said, any amount of fire would make me crap my pants, and actually touching it would probably kill me. I would also never be able to eat actual food again, and every night my appearance shifts back to what it was when I was turned. I guess I would not actually CHOOSE to become one, but if the change was forced, I would try to make the best of it.
Any other type of vampire, I'd probably say no.