Personally I'm already tired of Marvels style after Infinity War and Endgame but am aware I'm in the minority. Yet I wouldnt say Im tired of superhero films. I think they can avoid it so well because there's just so many different characters and storylines to keep things that healthy mix of "fresh but familiar" that the general audience likes. If I dont like Captain America or Spider-Man I may like Deadpool, Batman, GotG or Thor for instance. Most other franchises dont have this luxury: If I'm sick of Captain Jack there's no other cool pirates movies to enjoy.
They all share a lot of similar motifs and story structure but have a slightly different style to keep you interested. I know for me I have been suckered in by Marvel and fanboys constantly claimimg each new one is going to be completely different and change the game (spoiler, it doesn't, and this is why I really dislike them atm) but the hope is always there I'll get one I'm looking for even if I'm not liking the latest one - which happens. Thor Ragnarok was great after the mediocre first two. Logan was awesome after up and down xmen films. Batman Begins, Joker, GotG... you get the idea. I know i like the formula and basic super herrp story line so I can always be willing to give them a chance to see if they really do hit the mark Im looking for. Again, not all franchises can do. I think Star Wars can but hasnt yet.
Superheroes also dont need to follow canon and get a fair bit of leeway in regards to changing things, perhaps because comics have always had new authors doing their own spin on things. Look at Joker being different to any other Joker on screen, or Logan ignoring previous films to focus on being its own film in the directors style, and even MCU that often just ognores stuff from previous films but pays enough attention to keep the illusion of consistency (not saying they arent consistent but fuck they ignore a lot of the big stuff from last films in the earlier parts of the next ones, am aware thats unpopular but idgaf).
So yeah I dont know if they will ever get fully fatigued. Even of they do they can always reboot it and it generally works.