Season 1s are great, setup, some payoff, a bit of lead into the overarching story. Then season 2 to X. The heroes win and then lose in the final episode, cliffhanger to next season. People get bored. Final season is announced and they wrap up the show.
Some shows do a better job than others of having a satisfying arc in every episode. The Boys comes to mind in the sense that every single episode has a cool, self-contained story that gets resolved by the end of the episode, as well as an overarching story that spans the season.
Funnily enough, The Boys came to my mind as a negative example. It feels like every season hints at big things coming, but then the finale just kinda resets everything without those big things actually happening. And then the next season starts with them having to get the gang back together again.
I largely enjoyed the most recent season but the finale killed any excitement I might have had for the next season. The finale really avoided resolving anything at all, and basically undid as much as it was possible to undo.
See also The Walking Dead.
I agree with your assessment of the most recent season finale, but I would say in general every season has done a good job of having something cool happen in every episode. Like in the sense that each episode has a complete narrative arc. That’s not to say that the whole show doesn’t tease you a bit, but the individual episodes still have satisfying stories.
That is why I completely stopped watching TV, it’s just the same formula over and over.