There's one "but" with superpowers.
Namely - does a normal person have the opportunity to find out they have a superpower?
Suppose there's such a superpower - walking through walls. But even that doesn't sound super, super would be "running through walls". I.e. to find out about such a superpower, you need to get a good running start and at full speed run into bricks.
There are quite a lot of people with such superpowers on the planet, but few decide to even try. And it's hard to blame anyone for this: superpowers should from the very beginning come with super-responsibility and super-balls.
From this grows a philosophical question. There are plenty of potential abilities to "run through walls" - you can swim 1000km at a time, not sleep for weeks, write books, dance and be a genius investor.
How do you find out about this if obviously each of these superpowers will only manifest at the moment of super-stupidity? It really is super-stupidity to try to swim even 500km at once to find out about yourself that you can swim a thousand.
That's why there are no superpowers - because there's no super-stupidity. Only in movies about superpowers do we find out de-facto, and normal, human "powers" are always the result of a smart approach multiplied by luck. If there's no smart approach, there's no superpower - there's super-stupidity multiplied by super-luck.
You should always remember this when trying to find yourself an idol. If there's a person who can walk through a centimeter wall because they went long and hard toward this - they're better than the one who at full speed ran into a meter wall and found out they can run through them. Simply because you need to look more carefully at such a wall. Besides someone running through it, it's all covered with the guts and snot of non-superheroes.