Been thinking about this lately in the wake of American Alien, which, while I feel it's overhyped, is definitely the best Superman comic in a long while and'll probably justly end up a perennial. And the main compliment seems to be "it treats him like a real character". That's such a simple, minor thing, but a more down-to-Earth Clark seems to really be the thing of the moment, between this, Pak's Action, and t-shirt Superman probably being the biggest thing to happen to the mythology in the comics in the last decade or so. But it's not quite as simple as that; we still want Superman to be great, some even want him to be perfect (hence some literally complaining when he beat up racists to save abducted innocents in Action #45 recently). And I think the real issue is something Al Ewing hit on the head in an interview when he was talking about Judge Dredd:
"I'm incredibly reverent of Dredd - but I'm a bit too reverent to let any of it leak onto the page, or the strip becomes a kind of hagiography, and that isn't the right tone for Dredd. That isn't the right tone for any character. I always hated it when the only way a writer could point out how great Superman was to have all the other characters talking about it like they'd just creamed themselves - it made poor old Supes seem like a colossal prick, and I'd cheer inside when some menace would wipe the smile off his overly handsome face, then groan when he triumphed. Which probably wasn't what the writer intended."
For all our grousing about Superman not being treated as a hero, I think we're all pretty tired of him being treated as a god, at least by the story itself, which was never really the case in even the older 50s/60s comics where he was as close to godly as he ever would be. For example, Kingdom Come has gone in the last few years from being talked about in the same light as Watchmen and DKR to being considered overrated and wrongheaded - a story that's entirely about Superman as a grand figure, even though he never really lives up to that in the story itself. Whereas All-Star Superman, for instance, only has people from the future or with knowledge of the same acknowledging him as a legendary being, while most in the present just seem to see him as a friendly flying helper that everybody loves and thinks we should be more like, with those who know fearing his death because of the security concern or because they personally love him, rather than God dying or whatever, while the man himself wrestles with all he hasn't accomplished and his emotional inability to talk with Lois the way they both need. Morrison's Action doesn't treat him as a deity either, other than a symbol of resistance to the disenfranchised of Metropolis - only the Legion, again from the future, treat him as more, and the one issue to deal with the idea of Superman as a living icon treats that version as the villain. We all do still want Superman to act like a humane person with problems and failings, even if not pushed so far.
I think we all still want Superman in the sky, loved by just about everyone and always doing what he can to help. But despite what we might think sometimes, I don't believe we really want one who also doesn't ever ever ever get angry or scared or confused, or swear when he's frustrated and screw when he meets someone he likes and drink when he's with friends and generally be able to have fun on his own time, who has flowers thrown at his feet everywhere he goes. Or as Charlotte Finn put it better in part of her piece "On the Subject of an Imperfect Superman":
"The notion behind Superman is that he’s meant to be inspirational/aspirational. Superman stories should make you want to be better, to lift your spirit...If Superman never gets angry, or never cries, or never makes mistakes, then he either has nothing to teach in those areas, or has entirely the wrong thing to teach. The wrong thing being swaddled in the notions of perfectionism and toxic masculinity, that I drowned in far too much as I was growing up. I literally had people tell me that 'real men do not show emotions like that,' and holy shit, the damage that caused.
If Superman never gets upset despite having a reason to get upset, what is he actually teaching us about how to handle it when we get sad, or upset? What can he teach us about how to recover from and fix our mistakes if he never makes any himself? Never mind that the notion of Superman never making a mistake means that if the reader disagrees with him, it’s the reader who is wrong, and when you’re talking about a guy who lives an existence where a huge part of his life is hidden from his coworkers, what message does *that* send?
I think a good Superman story can have Superman be angry, be upset or make a mistake if it shows Superman dealing with these things responsibly, because then it can teach us how to deal with these things responsibly as well."