The problem with the concept of Super 'destroying society' is that people are society, so the police will just send Supers to fight supers.
They definitely would.
So summary is that superpowers:
a. Cause more mass shootings in places where the means for individuals to commit ones were not readily available. By giving certain people abilities about as good or better than having a black rifle and hundreds of rounds of ammo, you are spreading the means around. Also, a firearm requires a deliberate act - the individual has to go get it ("open up a trunk"), while superpowers are always available.
You might have to outlaw individuals with offensive superpowers from (sleep deprivation, or taking any alcohol or drugs not prescribed by a physician). It might be something that goes on a government ID.
b. A superpower is a form of
wealth. Today, you get moderately well off by [ playing correctly a complex game set up by our ancestors and then investing your entire lifespan]. You get wealthy by [absurd luck. Starting a tech company at exactly the right time in the right market. Rapping or acting. Nearly everyone will fail, you only hear about successes in the news]. Or inheritance.
A superpower is another way to get wealthy, and since it goes more to people who are suffering, it's possibly more 'fair'. Most of the ways you can get absurdly lucky and become actually wealthy (10sof millions+) require a substantial upfront cost to even try (and probably fail).
Many superpowers it's like becoming "set for life". You can do something really cool and get paid to show it off or demo it so it can be researched.
c. Where the above breaks down is that if superpowers can be 'leveled up by killing other supers' or it is possible to get a 1 in a million 'roll' on your superpower issuance and get something
hugely more powerful than anything else. Where most people just get healing or regeneration [since this is the trauma that the majority of living humans will eventually suffer - getting severely ill], what if it's
possible to get something crazy strong or that covers multiple power domains at once, but super rare?
Mind control
and near invulnerability, or tinker 10
and near invulnerability, or near invulnerability
and super speed, or super speed
and tinker 10, or tinker 12 by itself, or silver age superman, Akira level power, etc.
Someone like this is immune to the cops, maybe immune to anything the military has except nukes (which they won't use if the super stays in populated areas), and immune to every super that doesn't have a very high class offensive power. Or can just threaten to nuke a whole city, Akira style.
This would break central governments - they work because individual 'mayors' can't rebel and back it up but a super
can - reverting to a feudal system, where there couldn't be a strong central king because the individual nobles had castles and were too expensive to be dealt with except in extreme situations. This would be like that - maybe someone with an S class multi-power would declare that they own Dallas, and the authorities would have to try to work out some kind of new system.
The other issue is that at these levels of power, the earth itself might be too small a battleground. A series of battles between the highest tier supers might do damage similar to a nuclear war, creating a post-apocalyptic scenario when the dust settles. Bummer.