By the way, if you want power you'll have to leave Marvel and go to Superman!
Superman has taxed the creative abilities of writers for decades before I was born. In the beginning, Superman leaped in to save the day with the bullets bouncing off his chest. But it didn't take many stories before that gets boring. So he got more powerful, and more powerful and still more powerful taken to an extreme that became his signature.
The problem was Superman's invulnerability made it hard to write a good story. They solved it in 2 ways. Kryptonite made him weak as a kitten and he began fighting villains that were even more powerful than he was.
Kryptonite was good while it lasted, but here too, it's only effective for a handful of stories. Worse yet, with Kryptonite as an option one begins to question whether he's Superman anymore. At some point DC gave up and found a way for Superman to be immune to Kryptonite. A bold move from which they couldn't go back.
But Superman became the embodiment of paradox. He was the hero that gets beaten to a pulp in the worst ways by villains more powerful than him. He even was killed. On the one hand, Superman was the most powerful hero in comics. On the other hand, he took horrible beatings for 80 years and counting.
Would you want to be Superman if it meant you had to take so many massive beatings?
My favorite chain of events was in the 1980 movie. Superman went from thwarting a mugger who shot at Lois Lane and rescuing a cat from a tree to lifting the entire San Andreas fault with his bare hands and it didn't end there! When Lois and Jimmy were found dead he went into a rage like no other and flew around the earth turning back time. That movie kept my rapt attention to the very end.
The other one I liked was the second movie with General Zod. Zod was from Krypton too and had the same powers as Superman. I loved watching them beat the hell out of each other while smashing the city around them to pieces. It ended with the highly controversial move of Superman killing him. In general, Superman and even Batman don't kill. I for one thought General Zod deserved it!
The only reason the Superman movies were so good was because DC experimented and tried things for a very long time. This is a post about comics not movies.