Well... not as thrilled with the end of Picard S2 as I would have liked, but it was decent. Much better, I felt, than Discovery S4 (which I had to choke down, and which my wife finally got up mid-episode at one point halfway through the season, announced 'Nope, I'm out', and went to watch true crime shows in the bedroom).
A few thoughts, with spoilers since the finale just went up a few hours ago:
+I actually really liked Rios' decision at the end. He's right- this is where he belongs. Seeing him as a miserable loner in S1, fine, but seeing him as a Starfleet captain in the start of S2 was jarring- it didn't seem like he fit that role. I'll be sorry to see the end of the character, because he was one of my favorite parts of the show, but as endings go it was a rather good call. I love that he eventually died sucking on a cigar.
+Jurati... I'm iffy on this one, it seems like there are some holes in that whole circular path they gave her to becoming the Queen- Picard was part of the Collective at one point, after all, but never sensed her as part of the whole thing? The Borg found out about Earth via Q's machinations way back when, but wouldn't Agnes have... you know what, fine, whatever. I don't have to like it.
+The whole thing lead up to... a hole in space opening to reveal a horrifying threat to all life in the sector, which was quickly filled via a quick science-y bit in a couple of minutes. Didn't we do this already in this show? No metallic tentacles this time, but it felt like they treaded the same ground.
+Q... I didn't really get the plan with him 'dying', it still doesn't really make sense, but as a sendoff to the character it was pretty good, honestly. The reapport he and Picard had for so long was a lot of fun, and getting an opportunity to say goodbye was actually nice- that last moment of the two of them before the time jump really was emotional, and I get the feeling that it wasn't the two of them acting out their roles so much as genuine friendship between the actors. (Side note, if you ever get a chance to meet John de Lancie, he's one of the nicest and most quick-witted people I think I've ever had a chance to talk to.)
+WESLEY!!! Just... man, good to see him. My sole regret is that he didn't say 'hi' to JL as part of his cameo.
+OK, one more thing. Elnor. I liked his death. It added some honest-to-god gravity to the season, it made the motivations of characters that much stronger, it meant that the stakes were high as we actually lost a major member of the S1 cast early on. His reappearance as a hologram was a fun 'oh... OH!' moment, but I felt that they'd really done something surprising and clever with axing the character. Having him magically reappear as 'everything is fine over here on a different ship, promise!' kind of felt forced, and while I get that getting rid of THREE characters from S1 might have been a bit much (with Jurati and Rios being out), adding him back in here just didn't really feel like a good handling of the situation to me.