Thinking of your Superman example and an ubermensch having to think about everything, I think several comics and media that have explored aspects of this idea.

I remember reading that there’s a Spiderman story arc where it’s revealed that Peter Parker is holding back his “true” strength for nearly the entire time he’s been Spiderman. It’s only been his true strength of character that has made sure that he “pulls his punches” far enough back so as to not kill or harm the people he’s fighting or saving.

I also think about Robert Kirkman’s Invincible comic/animated series that explores how powerful people decide, either intentionally or accidentally, the fates of those around them, often with dramatic and violent conclusions. Invincible is the story of Superman if Clark Kent wasn’t raised by an American family in the mid-West and was instead raised for another more sinister reason.