Insurrection is irredeemable. I keep nothing but the title.
The Enterprise is on a mission stop the Borg, on Picard’s initiative. Like Guinan in Yesterday’s Enterprise, he can’t explain how he knows what he knows, he just knows, and he needs the faith and support of his friends to do it.
Data, operating without his emotion chip, is the first to figure out that Picard is under Borg influence and leading the Enterprise into a trap. When he expresses his concerns to Picard, Picard assures him that he is still Picard and not a Borg agent.
Having failed to convince Picard, he approaches the rest of the senior staff with the proof. It leads to an Allegiance-like situation but it divides the crew. Riker and Data are convinced that the Borg win if Picard is not removed from command, Picard is equally certain the the Borg win if he is removed from command, they can’t find a way to bridge the divide, and the titular insurrection is a mutiny on the Enterprise.
Ultimately it turns out the mutineers were right and Picard was wrong. He is left shaken that he could have been so absolutely certain and yet so wrong.
In the next film, Shinzon was intended to replace Picard. With all due respect to Tom Hardy (which is a lot), I leave him out of the film and cast Stewart in a dual role.
The conflict with Shinzon is resolved in the Trekky way. Picard gets through to him and convinces him that destroying Earth isn’t the best way to pursue his goals. They make peace and accept each other as brothers. This leads to another mutiny, as most of Shinzon’s crew still wants to destroy Earth.
The mutineers are thwarted and Earth is saved, but Shinzon is killed and his government collapses. His half-human son is not welcome in the Romulan Empire, so Picard takes him in as his nephew.
Also I use a different name for the tenth film, because Nemesis is my eleventh film.
The Enterprise is given a crucial mission to retrieve a McGuffin before the Borg find it and acquire it for themselves, which would mean pretty much the end of everything.
After the events of Insurrection, there are questions about Picard’s judgement where the Borg are involved. As a result, Janeway takes command and Picard is temporarily demoted to first officer. (Riker and Troi are serving on the Titan by this time, but we’ll find something for them to do.)
On the mission an encounter with the Borg goes horribly wrong. Picard is captured and becomes Locutus again, the Borg know everything they know, they race off to get the McGuffin and the Federation is doomed.
Janeway reveals that Picard (and to keep up the illusion, everybody except herself and Seven) had been given disinformation. Disinformation that the Borg now have and believe. It’s the Borg’s Insurrection ploy in reverse, and if they act fast they can end the Borg threat once and for all.
It works, and Janeway makes no apologies. She did what she had to do to save the Federation, and besides, Picard survived. Picard, who has been retraumatized and suffered more than anyone, understands. His friends, not so much.