I vote for Tim Russ as Tuvok head of Starfleet security
Captain Tuvok (still in Ops gold) recalled to oversee the investigation; subsequently promoted Rear Admiral and appointed the new Director.
It’s complete and utter fanwank, obviously... (!)
— but, in truth, they could do much worse.
I would hope that they would use at least the first episode of S2 (maybe the first couple if you include some sub-plots with the rest of the Scooby gang from
La Sirena) to wrap up a few loose ends, even if some of it (or even quite a bit of it) occurs off-stage:
Picard needs to go back to the Chateau, meet up with Laris and Zhaban (and maybe drag them along this time, at least for some of the season);
Jurati needs some sort of due judicial process over the death of Maddox, even if the official outcome turns out to be that she legitimately gets off by virtue of whatever Oh did to her — presumably on the basis of some forensic mind-meld to establish what actually happened (Tuvok again...?!);
Picard needs to go back to SFHQ and be officially exonerated and re-instated, even if he then promptly re-retires (!) — easiest opportunity ever to gather a few TNG and other relevant alumni in Clancy’s office;
(it would be nice to see Rios and Musiker get some official Starfleet recognition here too, after all that
they have been through)
there needs to be at least *some* reference to the in-house clear-out that Starfleet had to do in the fallout from all this, especially in relation to public explanations about Mars, the Utopia Planitia attacks and the Synth Ban — and the subsequent rescinding of the ban, or perhaps final confirmation of this if the initial response at the end of S1 was a temporary lifting of the Ban;
just as with Family after The Best of Both Worlds Part 2, Picard needs to resolve his personal fallout from all of this — at the Chateau? — with Beverley? — back to Nepenthe with Will and Deanna? — The Rikers visit him at the Chateau...?
OK, enough day-dreaming; back to the main event...