Given that this is their final season, let’s hope they pull off the sort of swan song they never got, something akin in feel to The Undiscovered Country.
They had their perfect send off in All Good Things. The movies that followed and the Picard series in particular highlight the truth in the saying you can never go home again.
I feel sorry for the fans who held off watching the new series but will now start doing so in anticipation for season 3. As the first season is one of the most cynical, cold and cruel things I’ve ever watched. I’d never been personally offended by a television series before this. And the second season isn’t much better. What they’ve done to Gene Roddenberry’s vision is unforgivable.
I have not seen any new Trek since Star Trek Beyond, but I have enjoyed reading the plot summaries of Picard Season 2 (Season 1 sounded too convoluted IMHO, but, again, hard to judge without actually watching it) - it sounds like a fairly plausible Q Episode, maybe a two-parter, stretched to season-length. Q does something stupid to mess with Picard and test him in some way, but this time there’s time-travel involved as well, and a look at what is essentially the Mirror Universe (but not, for canon-reasons). Sure, why not.
You make a good point about All Good Things, though. That is, indeed, the perfect series finale.