Here are a couple of examples of possible problems a strong or magical person might face:
There is a question:
One answer mentions a scene where a Klingon head butts Data and hurts his head on Data's super strong head.
And my answer mentions another way a Klingon named Worf was hurt - in a sense - by a head butt from a fragile human. Worf was raised by humans and was the biggest, strongest, wildest, and most dominating boy on the planet. And one day:
WORF: When I was thirteen, I was captain of my school soccer team. We had made the championships, and I was determined to win. Near the end of the second half, with the score tied, my team got a corner kick. The ball sailed up high. Both I and one of my opponents, a human boy named Mikel, leaped up to head the ball. He had position, but I was determined to score. I remember laughing with excitement as I threw myself at him.
DAX: Go on.
WORF: The next thing I knew, the ball was sailing into their goal. I roared with triumph and turned around to Mikel to gloat, only to find him lying on the grass bleeding. Our heads had collided when we both went up for the ball. I had not feel the impact, but I had broken his neck, and he died the next day.
DAX: It was an accident.
WORF: Which only makes it worse. Compared to Klingons, humans are fragile creatures. I realised at that moment to live among them I must practice restraint.
DAX: That must have been difficult for you.
WORF: At first. In time it became part of who I was, who I am.
DAX: And you're still afraid that if you lose control
WORF: Someone I care about might get hurt.
One culd say that the old Worf was defeated and even figuratively killed by the encounter with Mikel which changed Worf's personality and lifestyle forever.
So that is a good example of how a stronger and more powerful character can be hurt and in a sense defeated by a weaker and less powerful character.
Here is another, hypothetial, example.
In the ending credits scene of "The Last Adventure", the final episode of Duck Tales (2017-2021), the protagonists have defeated their foul enemies in F.O.W.L. and are flying home in the often crashed Sunchaser when Launchpad McQuack accidentially opens the cargo door and they are all blown out of the plane into the air.
As I remember, Gyro Gearloose and Lil Bulb are caught by B.O.Y.D., Gyro's flying robot.
Launchpad and Gosalyn Waddlmeyer grab onto Darkwing Duck's cape and use it as a parachute.
Manny the Headless Man-horse who is really a flying gargoyle catches Mrs. Beakley and Donald Duck, I think.
Fenton Crackshell-Cabera uses his Gizmoduck suit to save himself and his girlfriend Gandra Dee.
But I didn't see what happened to May and June, technically the youngest children present, or "Whatever Happened to Della Duck", to use the title of another episode.
Violet Sabrewing - and possibly someone else I didn't quite see - was levitated by her adopted sister Lena, who had recently developed vast magical powers including flying.
Huey, Dewey, and Louie, Webby Vanderquack, and Scrooge McDuck grabbed hands and formed a ring falling through the sky like skydivers sometimes do. But unlike skydivers, they weren't wearing any visible parachutes.
Thus it seems to me that depending on the height they were falling from, they had only seconds or minutes left before they slammed into the water at fatal speeds.
Darkwing, Launchpad, and Gosalyn aleady had their makeshift parachute at or over its capacity. Manny, B.O.Y.D., and Gizmoduck could probably carry one or two more passengers apiece.
But as far as I know May, June, Della Duck, Huey, Dewey, and Louie, Webby Vanderquack, and Scrooge McDuck, and maybe also Ludwig von Drake, were all falling. And I doubt that Manny, B.O.Y.D., and Gizmoduck could catch them all in time.
So Lena may have had to rescue some or all of the falling protagonists. I don't know if Lena can levitate more than herself and two other persons at a time, the most I have seen her do. So Lena might have had to drop some people to save others. Even if Lena could levitate and save everyone, would she notice and act in time?
So I can imagine a sequel in which Lena failed to save some of her friends from falling to their deaths, and perhaps is very depressed as a result.
What if Lena dropped Violet Sabrewing to save Webby? Violet may have fallen to her death, or Lena might have stopped Violet's fall after Violet fell for hundreds or thousands of feet, terrifying Violet. Lena's adoptive parents might throw her out of the house, or if they forgave her, Lena might run away to avoid facing them.
Lena earned the right to be part of the McDuck family in "The Shadow War", but if all the McDucks die, or if only some survive and they blame Lena for failing to save the others, she might no longer be wecomed by any surviving McDucks.
So Lena might return to her old lair and lie around depressed all day, while she should be out being a superhero; saving innocent people from Magica De Spell, magical beings from the Phantom Blot, stopping the crimes of the Beagle Boys, etc. I can easily imagine Lena, one of the most powerful beings in the Duck universe, becoming so angst ridden that she makes Peter Parker ("Spiderman") seem like a normal, well adjusted teenager.
Or Lena might have used her magic to kill Launchpad McQuack, blaming him for the deaths of her friends, and thus turned toward the dark side and started to become as evil as her creator, the fate Lena was terrified of in "A Nightmare on KIllmotor HIll".
Similarly the less powerful superhero Gizomoduck might be terribly depressed for failing to save everyone.
Every person - including superheroes and supervillains - who has a complicated social life and a number of different social roles in a society can enjoy or suffer their roles in a complex society. Ordinary events and decisions which have nothing to do with battles between superheroes and supervillains can give them great pleasure or pain.
Furthermore, every person changes somewhat over the course of time. Someone can become a little - or a lot - better or worse with the passage of time.
There is a saying that "all power corrupts, and absolute power corrupts absolutely". That is not totally true but does have a lot of truth.
So a story about a superpowered, invincible, and invulnerable person can have a lot of suspense for some readers, if there are hints that a superhero could possibly turn evil as their power corrupts them, or a supervillian might possibly reform partially or totally.
Thus it seems to me that some stories about overpowered characters can be interesting.