1. No magic tricks. The crew are stranded in the 21st century with no ship. Let's see how they get home. Right planet, wrong time.
2. No reset button plot. A common cliche in time travel stories, this involves everything being put back the way it was and nobody knows anything about what happened.
3. Rios to pay his penance for breaking the temporal prime directive. Butterflies, indeed? He's trampled a few.
4. Agnes not to reappear and bring the crew back home. No, she's gone and should not reappear to save the day.
So no, on reflection, I did not think this was not a great episode.
We join the crew standing around and talking in Chateau Picard, with the sense of urgency which they've had since they arrived in the 21st century. Soong is still out there, planning to sabotage the Europa mission which launches imminently, but hey, let's stand around and talk.
Tallinn will break her cover to keep Renee Picard safe, while the rest of the team will try to track down Soong and stop his sabotage efforts. Tallinn dishes out some more magic tricorder boxes, then beams out in a box of blue smoke... and Picard leaps into the box at the last second. He can see (and this is conveyed well) that Tallinn is planning to sacrifice herself if necessary to save Renee, following the Borg Queen's cryptic "one Renee must live, one Renee must die" line in the last episode. What's with the cryptic clues from the Borg? Can we go back to Resistance is Futile? We knew what THAT meant. The Borg Queen has become nothing more than a Battlestar Galactica hybrid, spouting philosophical nonsense.
This leaves the main plot: will Soong be able to sabotage the Europa mission? Rios has downed all the drones, so direct intervention is needed, and Soong takes matters into his own hands. Using his money and influence and his own inimitable brand of rude charm, he engineers a meeting with Renee.
The crew regroup, having completed their mission and saved the day. Now all they have to do is get home. Except of course that Rios The Butterfly Slayer is staying to mess up the timeline. And Q suddenly, despite dying, has one final click of his fingers to spare, and can return Picard and the crew back to their own timeline. The whole mission was contrived by Q so that Picard would realise that Q didn't want to die alone. And sure enough, Picard hugs Q before they go their separate ways. Perhaps the mission was designed so that Picard would face his past, or have the courage to start a relationship with Laris? I honestly don't know - this final episode was rushed, crammed full of stuff, and did I mention that we aren't home yet?
The crew are transported back to the bridge of the Stargazer, with the Borg Queen in full assimilation mode. Except that the Borg Queen is now a very old Agnes Jurati (but looking good for it). The Borg have come to join the Federation to help them stop a massive explosion at the middle of the galaxy. It all goes smoothly, except that one ship has trouble sorting its shields out... surprise! Elnor is resurrected and alive and well on the Excelsior. A new era dawns between the Borg and the Federation and all is well with the world.
The gang all reconvene with Guinan (back to her Whoopi Goldberg guise) who fills Picard in on all the historical gaps: Rios The Butterfly Slayer set up a clinic with Teresa and helped those in need - there's a photograph of them together behind Guinan's bar. Teresa's son, Ricardo, went on to become a biology expert. Renee went to Jupiter's moons and brought back a biological sample of a microbe, which Ricardo identified as a cure for Earth's ecological ills. So that's what it was all about. At least that got tidied up - not sure why not having the ecological fix would cause humanity to become xenophobic overlords, but it's possible.
Even Picard gets to go home to find that Laris is packing her bags, but persuades her to stay. We don't get to see them kiss - surely the biggest emotional payoff since that near-miss in the first episode - but we can be sure that all is well in Chateau Picard.