Always reminded of this hilarious clip whenever the heights of Kevin Hart and The Rock are mentioned:

https://youtu.be/gYic1W-1ybE?t=453

Have you seen ‘My Adventures with Superman’? I think they did a great job in this series dealing with the issues you mention.

As an aside, One Punch Man is an example of a series where the protagonist is absurdly OP but super entertaining nonetheless - not a comic book series though, of course.