Haven’t read the comics yet, but the show Invincible has an interesting deconstruction of this topic. When Mark comes on the scene, superheroes are popular and generally seen as virtuous.

Mark and his opponent are so much more powerful than any other heroes who came before and he’s unable to stop their battle from destroying huge chunks of a city and killing thousands.

The government understands his limits and the elevated stakes, but the people on the ground vilify Mark and he has to deal with his guilt and their hatred throughout the series.