First: Most people who use cheats in video games eventually either stop using them or stop playing the game altogether, because it gets boring.
Many people who win the lottery get a bit of splurging out of their system, then invest the rest into financial security but keep living their loves mostly like before.
So there genuinely might be some people who will eventually settle into just fixing their most glaring problems and then just keep living “regularly”, possibly with the occasional minor indulgence.
Then there’s people who are willing to go to extreme lengths to enforce their beliefs even without superpowers - imagine super-powered criminals and terrorists, but also super-powered firefighters, doctors or scientists.
And then there’s everything in between.
So, if it’s just one (or maybe five) people getting superpowers, it’d probably be a roll of the dice. Maybe there’d just be one person going through life easier. Maybe we’d get lucky and someone solves a major problem for us. Maybe we get unlucky and every president that doesn’t reinstate segregation gets assassinated.
If it’s more people getting powers… well, there’s already a lot of fiction exploring that in-depth.