As @ArmandoPenblade says, Dark Knight Returns is probably the story that comes closest and it’s pretty brilliant if you can get past the Miller’isms. BvS basically borrows the idea of DKR, but without taking any of the narrative structure that makes the concept work in the comics. In the comics, Superman has been manipulated into becoming a government enforcer and that gradually builds up to the final fight, since Batman is the ultimate vigilante. The climactic fight not only makes sense; in the way the story builds up, it seems inevitable. The rationale for the fight in BvS on the other hand… it’s not just dumb, it’s an insult to the intelligence of the viewers.
I think Balasarius hits on the versions of Superman that I’ve found interesting: Superman is a god, but what makes him interesting is his humanity, and how he resolves that conflict. But that version of Superman has never hit the screen. And - much like Cap and Thor (who also shares many characteristics with Big Blue), he probably works a lot better together with other characters than on his own. Sad that the first time they try to put him together with other DC characters, they mess it up so badly as they did in BvS.
Though returning to the Marvel Cinematic Universe, I agree with Nesrie - it’s important keep reminding oneself that the people who put it together are an amazingly talented bunch. Because it seems so effortless, it’s can sometimes be difficult to remember that creating such an amazing run of movies over so many years has to be anything but easy. If it was easy, the DC Universe wouldn’t be struggling as badly as it is, the X-Men movies wouldn’t be such an incoherent mess, and Star Wars stories wouldn’t be on a temporary hiatus. The MCU really is an incredibly movie-making feat.