It depends on a number of factors.
I don't think that people simply having power is a problem. I also don't think that totally sociopathic behavior is the norm. People just generally don't 'screw stuff up' for the heck of it, people who think that is what they would do would probably be quite surprised at their own reaction to having the abillity to do it.
Of course the level of power DOES figure into this, if we're dealing with it on a fairly personal level, like being able to flip a car or something, that's probably not a big deal. If we're dealing with the power to say level buildings through raw force after having a bad day, that's another.
There is also the question of how willing these people are to live within society and it's laws. I missed the big registration thing, but understand I've always felt that was a double edged question. Typically comics and such explore it from the perspective of racism and try to present regulation as a bad thing, with any attempt to regulate super powers or abnormal abillities as being something that will lead to abuse or extermination, I don't quite think that's the case. Before it got de-railed by people wanting to make a real-world liberal analogy (superhuman Gitmo!) I think Civil War (Marvel Event) was raising some interesting questions here, though it got away from that and turned into a very loaded right/wrong equasion and forgot what it was originally supposed to be about. I personally do not think registration would be a bad thing, and going along with it would do a lot to demonstrate a willingness to live within society. I've always found a lot of arguements in comics to be fairly ironic, that the superhuman mutants (or whatever) that are supposed to be good guys and make noble speeches about living in peace with humanity and such, also frequently make a big point out of putting themselves above any kind of law or regulation (which does waffle at times). Something justified by the existance of some rather unlikely psychpaths always working behind the scenes.
In short, I would expect there to be some degree of regulation and registration as a matter of common sense. I'd be wary if there was resistance to it on a massive scale, as I pretty much feel anyone not willing to work with society and put themselves above it is kind of making a point about things being as bad as possible.
I tend to think in the final equasion things like registration wouldn't be that big a deal honestly. People with powers like telekinesis are liable to want to use them in the private sector, and operate publically, rather than becoming vigilantes and criminals out of hand like in popular fiction. After all if someone is willing to pay you millions of dollars to manipulate hazerdous materials at a safe distance, raise things from the ocean floor, or whatever else (depending on power level) why would you need to rob banks, or hide from the goverment. You could do quite well letting everyone know what you were and selling your talent as a professional.
There are already a lot of people far, far, more powerful than me, and I could die at a moment's notice from a number of things without any kind of superhumans or telekinetics around. Adding one more thing like that doesn't paticularly bother me, especially if it works with the rest of society.
I'll also admit, I'd be jealous, it's human nature. I'm jealous of a lot of people that have things/talents/whatever that I do not, BUT I don't let Jealousy rule me. To be honest for all of the envy, I also tend to feel happy for people that are doing well. It's one of the reasons why I'm not especially bitter about the rich, their tax breaks, and other things. Sure, I wish I was rich too, especially if I was basically born with a silver spoon in my mouth, but I'm not going to hate on people for it. To invoke my ire it comes down to what you do with what you have. As a result I tend to be fairly accepting of the antics of Paris Hilton (hey, she's rich, likes to party, and uses her money to enjoy life and be an irresponsible playgirl, I might do the same thing, she doesn't generally hurt anyone), but less so of people like high powered bankers who have more money than they, or the next 10 generations of their family could ever spend, and yet feel the need to exploit people brutally to make even more money. I don't feel people are under any obligation to be philanthropists, but I don't care for bastards who kick people while their down and trod on them because they can.
