Most comic book superheroes (including Superman) are for kids
Also, Superman being his typical archetype doesn't mean that he doesn't have doubts or failures. Once again @MartyMcFly perfectly explained Superman's character earlier.
Comics have also evolved, like the big screen portrayals, to the fact that adults read them too. Typical doesn’t equal interesting.
Superman has been printing long enough that the Boy Scout image probably isn’t the most typical anyways. And no, the old comic failures were negligible. You knew everything would be fixed by the end and there wouldn’t be any real consequences.
I appreciated the DoS run so much because, for the first time it was unpredictable. There were semi tangible consequences (like Supergirl getting punch into waffle mix, etc). If there was anything wrong with the current portrayal, it was that it wasn’t explored enough.
We’ve seen Superman with training wheels long enough. He’s just fine in a world, that bleeds. Just like ours.