OK, so I just watched the most recent episode.
Adami….my dear friend… you are literally among my top 3 favorite people here, and I honestly feel a measure of brotherly love for you.
…but… you’re wrong and I’m going to tell you why.

The reason why the heavy nostalgia works right now, on this show, right now can be summed up in one word. NEMESIS.
The way you felt about the first two seasons of Picard is exactly the way I felt about Nemesis. It is the only Star Trek that ever actively pissed me off with how terrible it was. And the fact that it was the TNG crew’s last hurrah made it all the more insulting. Even as I think about it now, it irritates me. It would be like if Metallica had retired right after releasing St. Anger and Lulu back to back. That’s how bad Nemesis was. The TNG crew deserved better, and they knew it. Even as they were trying to promote Nemesis there was an air of disappointment. They knew they had all been robbed of a decent send off, and they shared their fan’s disappointment.
But now, TNG finally has a halfway decent “victory lap”. We NEEDED this. Heck, THEY NEEDED THIS. This is to TNG what The Undiscovered Country was to the OG crew. Ya, it’s not Wrath of Khan, but it was a way to get the stink of FF out of everyone’s mouth.
But ya, it was pretty nostalgia heavy. I’ll give you that. I just hope you rethink it from that perspective and warm up to it a bit more.
Nothing but bromance for ya…
So, I feel ya, I love ya, and I need ya. Or something.
But we're not that far off from each other. I stand by saying "It was so predictable. So telegraphed. So obvious. So cheap. I'm angry at myself for letting it work. Yea, I had the feels, even though I recognized how lazy it all was. I can't defend it at all, but it had some impact on me."
It WAS predictable and cheap and forth and didn't make a ton of external sense, AND it had an impact on me. Obviously seeing everyone on the D doing their thing had an effect. But I won't say it was very well done, it was cheap and obvious but still largely effective. So I'm mixed on that.
And, oddly enough, final episode aside, I would compare this show....STRICTLY quality wise, to Nemesis more than anything else. It's a bit better than Nemesis and will hopefully have a much better ending and send off, but the writing quality is pretty similar to me. A really bad story line that makes little sense, everything is dark and evil, blah blah Picard offspring (or clone or whatever), blah blah action and fighting non-stop, and some good character moments mixed in. This show has better character moments and a dumber story, so I'm putting it a bit above Nemesis.
But at this point, to me, and possibly only to me, this season is just fan-fiction. It's writers using toys other shows already gave them and doing wish fulfillment. There's no new stories here or new exploration or any of that. It's simply people writing fan-fiction and being lucky enough to get the whole cast for it. So I'll watch the last episode with that mentality. I'll try to enjoy the nostalgia of everyone back together. I'll look out for the endless cameos/member berries they'll cram in as well and try not to expect anything more than that. Which, in and of itself, is sad for me.
That said, I did have an idea for the very ending that is Star Treky and hopefully something they try to do. Since the Borg are about to (and obviously will) destroy much of Earth's defenses and such, I think after it's all said and done, it'd be cool to see a ton of other federation and allied species coming to help earth and be there for them the way Starfleet has been there for others. So an ending show of Earth with Vulcan, Klingon, Ferengi, Bajoran, maybe even Romulan ships, etc all working together to help Starfleet rebuild would be a nice ending. Doubtful, but I can see it as a possibility.