Imagine you had the opportunity to be Superman, would you take it? Sure, you'd have the ability to fly, but what about all the baggage that goes with it? Say some omnicient being (think Q in the Star Trek TNG series) makes you this offer. I'll give you virtually unlimited power, but you must use it for the benefit of mankind. What do you choose?
Me? I'm not sure how selfless I am, but then again, I wouldn't mind being able to fly.
When contemplating this question a couple of things come to mind.
We've recently discussed Superman's ability to procreate, so one must keep this in mind before deciding whether or not to accept.
And even if you can have a relationship with a person who doesn't have super powers, just look at Spiderman. Talk about conflicted.
Would it be worth it?
I suppose on the plus side you'd have the admiration of most of the world, minus the super villians that would likely show up to challenge you. I mean, you'd probably be like a rock star times ten! If you're someone who isn't into long term relationships, this might be just the ticket.
But remember the old tale about the monkey's paw, be careful what you wish for.