The first episode really managed to hook me in and get me interested. I wanted to learn more about the Romulans and why Synthetics we're banned. I wanted a more sinister side of Starfleet and to watch Picard have to deal with it.
Unfortunately, that initial hook gave way to a slightly jumbled mess. Over several episodes, an annoying tendency to arbitrarily skip around timeframes to stumble through a slightly dull narrative, combined with a stream of fun but ultimately confusing cameos (and possibly also some new characters who were given the same treatment with even less context) made for a bit of a jumbled mess. Gone were the sinister undertones, replaced with a rather tempered clue-to-clue romp, where every clue was immediately solved without any difficulty.
More and more characters were added to the roster, all intertwining through yet more flashbacks, and none given much time to actually develop personalities or interests.
Luckily, a much more interesting plot around secret Synth number two, a Romulan secret agent lover, and a broken Borg cube, allowed the show some space to actually flex it's narrative muscles and dig into some of the more nuanced and interesting areas of Star Trek's lore. Throw in stellar performances from both of these characters and an evolving, interesting riddle around Romulan "prophecy", and Picard began to feel a little more interesting.
By the time Soji is activated, I was fairly hooked. I thought the way Picard reacted to the Borg Cube was really cleverly done; I loved his interventions with SevenOfNine; and the whole sequence with the Romulan meditation was eerie and tense in all the right ways. Plus, the whole subplot around Hugh and the EBs was just a very Trekkie concept.
That this built into a quite interesting (albeit far from original) twisting final act, where we learn the truth behind the prophecy, and allow the Synths the chance to break the cycle, made for an excellent second half. I even enjoyed the sudden Ryker and family intrusion(s), particularly because it let the show slow the pace for a moment, whilst also giving us an excellent character (and what a performance!) from Ryker's kid.
Throw in some great design moments (I loved the Orchid ships), incredible CGI and VFX for a TV show, and a decent, albeit overly telegraphed, ending, and I thought Picard wound up in a pretty solid spot.
Plus, of course, it's just great to see the titular character back on screen. This felt like a true homage to one of sci-fi's best creations. Everything from the Borg to the deeply personal relationship between Picard and Data was explored meaningfully and done justice, whilst his rougher edges were still fully on show. This was character interrogation, not just mere flattery, and whilst I think it could have done more in this area, what we got was good enough.