I'm happy with PIC Season 3 as TNG's Swan Song. I'm satisfied with
that as an ending for them. They've had their "Star Trek VI". So having them all together again and on the Enterprise-D, I don't need to see that again. I wasn't happy with
Nemesis. With "All Good Things", I knew they were going to movies, so it never felt "final" even in 1994. It's also only an adventure that Q and Picard remember first-hand, except for the poker table scene. With the ending of PIC S3, all the main characters remember it first-hand.
Although I don't disagree with others who've said before that it should've been a separate project from
Picard as it was during the first two seasons.
Going forward, after the current shows have run their course, I prefer either Post-
Picard or Post-
Discovery. It doesn't absolutely have to be either of those, but it's my preference. I'd like Captain Seven and the Enterprise-G, but it doesn't
have to be that. SFA being Post-Disco, I'm all for. It's an era that desperately needs to be further fleshed out. By the end of DSC S5, I still didn't feel like I was as familiar with that era as I think I should've been by then.
As far as the concepts, as long as the execution is good. I was for
Section 31 as a concept, but the execution of the TV Movie was
terrible. So, concept isn't everything. Execution matters more.
EDITED TO ADD:
PIC Season 3, according to Patrick Stewart himself, was mandated by Paramount to be a TNG Reunion. So, that's what was going to happen no matter what. Cutting-and-pasting a post of mine from last July where I cited where he
said this.
Making It So, by Patrick Stewart, Page 435-436:
"For Season Three, our last, Terry Matalas, by then Picard's showrunner, told me that the studio wanted a full Next Generation reunion. Ugh, just what I had firmly said I didn't want. But that had been three years ago. Now I was less resistant, having enjoyed working with Jonathan, Brent, Marina, John, and Whoopi. As an executive producer, I had a say in how we might go about achieving such a reunion. I told Terry, "I like the idea, provided that we don't bring them back all at once. Let's trickle them back in.
It was essential to me that each TNG character came into the picture because he or she had a specific contribution to make and it wasn't just sentimental window dressing. If Jean-Luc had changed so much over the years, so, too, surely, had the other members of the Enterprise crew. The writers, bless them, took this to heart."
I'm glad I bought that book!