Thoughs:
I feel like Rios is leaving. They were telegraphing the hell out of that punch. i could be wrong. Season 3 is looking like an older folks reunion so there might not be room, anyway.
The whole extended metaphor of Picard's crazy mom killing herself was stretched way too far. Think it was pretty obvious from the beginning something like that happened. For someone in charge of the biggest weapon delivery system the Federation possessed, who had also been nearly assimilated , had his brain controlled by an alien probe, been tortured by Cardassians, etc.. that NEVER came up in psych evaluations and addressed? He had an empath-councilor bumping elbows with him every day. For Years.
But I get it was needed for the series. It does have a kind of 19th century Bronte "Crazy wife in the attic" sense to it. It was fun seeing Picard fire an French resistance pistol. Picard has now fired a P-38 or whatever that pistol was, and a Thompson Submachine Gun. Seaspon 3 should include him shooting a bazooka or flying a Spitfire for completion.
I did like the episode. I gave it an 8, because standing on its own, I think it earned it. But I am tired already of the arc. I never cared much for Jurati, and the new Borg Lite can go boldly into the galaxy and fuck off. It's fine. I thought at first this season was going to have Rios and Jurati either fix what went wrong or end up as friends. But he kind of just shrugged when she was gone. I get it.
Elnor can become the new Duncan Idaho. Bring him back once in awhile, only to get him killed again.
Jeri Ryan is capable of more than they have been asking of her this season (range from mild annoyance to mild anger) but she's doing very well with what she's been asked to do. Same with Michelle Hurd. I appreciate they haven't really tried to create some sort of overt chemistry between Rafi and 7. Doesn't seem like their style.
There is no redeeming quality to this version of Soong. What is his motivation? Also what happened to not-Daj? Characters just disappear and reappear in this season.
For a season that is supposed to deal with Q, there's not a lot of Q.
I agree with
@Lord Garth , FBI Man will return.