All in all, pretty darn happy with the conclusion. An epic finale, great character closures. For picard he finally "got it", the scene he messed up before when he was captain first, father second and drove Jack away. This time his character made it full circle, giving Jack that hug and connection he so desperately needed.
I loved the scene with Beverly and the weapons, everyone giving her the gawked stare and her shrugging, "a lot happened in 20 years". That was great.
If there was one thing "missing", it would have been nice to have Laris on the final episode, have her meet Jack, remind everyone that Picard not only has a son but a romantic partner as well.
If I were to nitpick one thing, its that the Borg Queen let them in. I could respect the arrogance at a time of strength, but this is last ditch effort to restart your people, and this crew has beaten you before. You don't take that kind of chance, no way no how. In my headcannon, the cube was so cannibalized that its defensive systems were just inoperable and the enterprise was able to get aboard, and it wasn't until the Queen saw Jean Luc that they knew the enterprise was outside and ready to be targetted. That to me would have made so much more sense for the current narrative. I get that sometimes your Villain has to villain, be arrogant, and give the monologue....but not when your in an old jalopy barely scrapping by.
One thing I'm confused about Data. Data had an emotion chip installed in teh early movies, yet they act like the emotion thing is completely brand new. Am I forgetting some history there? (certainly could be, a lot of trek I have probably forgotten).
I do think Borg element was confusing with the Borg season 2 part, and it would have been good to remind everyone that it was Voyager and Janeway that brought these current borg to their state (I had to look it up as I couldn't remember).
But yeah, overall this was a great season of Star Trek, really enjoyable. It had its lumps, but it was a wonderful send off to the "last generation", while bringing up the new guard should they want to continue shows in that vein.