Star Trek is almost a perfect example. For one, it never had the widespread appeal that would have a movie studio greenlight a project akin to what is being described in the OP.
Additionally, they did a great job of, no matter how abstract or "out-there" the threat, always making the immediate danger to the crew and characters people cared about the most salient thing. Viewers were always way more interested in how Kirk and Spock would survive, even if the universe would also be destroyed. For as much cheese as there was in the show, ST had some decent writing.
even as a comicbook fan, I can't say that is particularly interesting, or rather, I'd say that idea would almost certainly be better suited to an animated video.
But no, the market has shown that such a movie would have a passionate base, but would not appeal beyond people who already cared about bats and supes.
The vast majority of people care more about seeing Clark rescue Lois than about some demonstration of how powerful Superman is. Think of the Super-kid in Superman Returns: To comic fans it was terrible, but for everyone else who doesn't care about continuity in that way, it added a personal dimension which drew them in to the film more.
I'm not saying people are going away thinking he was the best character, but in terms of building traditional movie suspense and all that, it is a really typical sort of role. I'd imagine people who aren't so invested in these characters that they post about them in their private time just didn't care outside of "OMG Superman, save your baby!"
I'm not sure about that. I mean, this is Trek. Like Star Wars, people live/swear by this stuff.
Indeed, character development, and a believable approach to the whole starflight thing, is really what made the show, whether they saved the whole universe or just Star Base Whatever. But, imho, I think what also made universe-saving adventures work in Trek is that they were already out among the stars, a huge, spectacular theater by definition, whereas superhero stories tend to be earthbound.
I'm just saying, if done right, a grand scenario could work in a superhero flick. But yeah, as you and Sin I Am pointed out, it would be a major challenge which would probably lapse into a quick-scheme, profit-seeking FX-heavy dud.
Maybe Spielberg should handle it...
__________________
Shinier than a speeding bullet.
Honestly if it was put into the story well and it worked, I think the general public would eat up huge power feats from guys like Thor, hulk or superman.