Yeah, you're entirely correct. I mean, I struggle to think of how many times villains actually are defeated on film.

Oh wait, they're always defeated. All that is needed for dramatic tension is the belief, if only for a second that he hero may not prevail, even if you know he will in
the end. Every hero does anything required of them in the context of the story.

People failing to relate to a character is a failure on behalf of writers, not a failure on behalf of the character.

No, it's a failure of people who make the argument that Superman should be able to fine the perfect solution to a problem that he's never dealt with before, on his first day. Or that he should ALWAYS be able to get out of things without making difficult choices, not once should he have to sacrifice for the greater good, why should I care about someone that omnipotent?