I’m a big fan of Supes myself, but it depends on who’s writing him and what the goal is.
He is at his best when it’s a problem he can’t punch away, it’s about courage, and honor of defending others. Superman without powers is still the same stand up powerful character, that is crux of what makes him interesting.