I had some very mixed feelings about the third and final season of Star Trek: Picard. I was excited to see all the TNG characters coming back, and especially happy that they had all changed as people since we last saw them in very believable and compelling ways. It didn't feel like a forced or by-the-numbers "reunion", it was a compelling story about these old friends coming together to fight a new threat, which held a vendetta against them due to the mistakes of their past.
Then [spoiler alert, I'm not sure how to do inline spoilers here...]
They revealed that said threat was the Borg, the most obvious possible villain for a TNG reunion. That made the entire season feel less like a good season of Star Trek, and more like an Avengers film. It also felt out of character for the Borg, because they're supposed to be a mindless destructive force susceptible to neither reason nor emotion, rather than a ruined civilization on a quest for revenge. The season finale was one of the most epic and tense episodes of television I'd ever seen, yet it also felt kind of empty and by-the-numbers, and left me uncertain as to why the writers felt that TNG needed a third "series finale" (after the actual series finale and the last movie).