Overall I liked it, but I agree, it didn’t really stick the landing and unraveled a bit as it went on.
I think the part(s) I’ve liked the most and will take away as a fan long term:
Data and Lore merging. As contrived as the whole thing was to get Data back in the show, I think the idea of what happened here made a lot of sense. That Data’s final victory over Lore was growing organically and then effectively learning from Lore just as he’d learnt from everyone else.
Geordi putting the Enterprise-D back together as a side project was always a cool idea, and seeing it again, though a nostalgic fest, was wonderful
Odo and Worf staying in contact after DS9
Seven being an annoying, obstinate but ultimately awesome starfleet officer come captain
The Picard family breakthrough with the revelation that his son had secretly confronted him about family and been told that starfleet is the only family he never needed … that was a good Picard character moment that works well in the whole continuity.
Setting the stage, at least tonally, for what the next “Next Generation” can look like as a Star Trek show. So far, all the new star trek we’ve got since Voyager has either been a prequel or reboot, except for Picard, where even S3 was so heavy on nostalgia that it doesn’t really count as “new”. Discovery went into the future, which was cool. But it’d be nice to see how things progress and continue to do Trek in a way that is modern and new, where, for example, the Shaw/Seven dynamic just felt like a fresh take on Trek.