This crazy idea I came up with a few years back, pre-Picard, which would be incompatible (now) with Prodigy and Picard, was basically a 13 episode anthology series that was inspired by Seven Soldiers of Victory... building a team that never actually all meets to face a threat that doesn't exist in a single time and place. Below's an outline... the full doc is quite extensive. I'm proud of it, but it doesn't work with what has aired since I wrote it.
---
Episodes 1-3, "Legacy" were about Lieutenant Molly O'Brien in 2399 to team with Julian Bashir (Section 31 leader) to find out why the remnant of the Obisdian order blew up a third of DS9 and killed Chief O'Brien and Keiko. Turns out, O'Brein was developing a long range transported technology based on the Iconians, and the Obsidian Order remnant wanted to use it to transport quantum torpedo's to the worlds of the Federation Alliance to win the war. It would deal with Molly's feelings about growing up exposed to constant danger and being moved around the galaxy. She would resent her parents but her experience would make her understand them. Bashir would be her guide in that. As head of Section 31, Bashir had spent most of the 2380s and 2390s trying to stop the Obsidian Order remnant.
Episodes 4-6, "Lost" is about Chakotay and Torres, stuck 200,000 BC. They tried to implement Quantum Slipstream technology as a proof of concept on the Delta Flyer, and ended up stranding themselves in the distant past. The arrive as a grand alliance of races were overthrowing their oppressors, the Iconians. The Iconians would try and win the war using their portal technology, but doing so unintentionally caused a False Vacuum Catastrophe. Entire systems got pushed into subspace. The Iconians manage to stop the Catastrophe over 20 years and destroy themselves. Torres and Chakotay realize they needed to plant the solution the Iconians came up with across the galaxy so anyone 200,000 years hence trying to use the Iconian portal technology would have a solution to stopping the false vacuum its use would unleash. Chakotay would get to be an archeologist, but in reverse.
Episodes 7-9, "Time" was about Jonathan Archer, who vanished (not died) the day after the NCC-1701 launched in 2245. he is rejuvenated by Daniels who (as we'd find out) sets Archer out to recover the pieces that Torres and Chakotay left, scattered across time. Archer would travel to 4 billion BC< 2273, 2295, 2327, 2364, 2399 and 3064. His mission gets him to see the full flowering of the Federation he helped build.
Episodes 10-12, "Destroyer" taking place in 2437, involved General Worf, the greatest hero in the Klingon Empire, who like Kor, outlived everyone and would could not die in battle. The Klingon Empire is at it's greatest extent ever, as partners of the Federation. The Federation is the shield, the Klingons the sword. But Worf has been denied his glorious death. Turns out, Qo'onos is destroyed when a great output of energy begins there and destroys the system, expanding outward unstoppably at FTL speeds. The Vacuum Catastrophe has begun. The broken empires is preyed upon by its enemies and Worf goes on a quest that leads him to to the long abandoned Terok Nor as the false vacuum consumes everything
Episode 13, "Destiny" tied it all together. Taking place in 200,000 BC, 2399, 3064, 2437, and 3060.
Chakotay and Torres in 200,000 BC put the anti-vacuum technology in a vault and seed its location across the galaxy. They die as radiation from the galactic-scale solution (that wiped out all "ancient" life of 200,000BC causes them to succumb.).
In 2399, Molly and Bashir find and stop the Obsidian Order remnant developing the Iconian portal tech Miles began working on (and was nearly done with). In the process, Molly discovers from her father's nots and Obsidian order research that while the portal would send the quantum torpedoes, the untindened False Vacuum side effect would occur. Archer would project himself from the future (hint hint) and lead Molly and Bashir to Chakotay and Torres' vault location (which he discovered in his 3 episode arc). They get the device. The entire Obsidian order is destroyed except for one, at the cost of Bashir's life. Bashir avenges miles and saves Molly though. Molly, realizing that knowledge of the portal technology escaped, resolves to wait on Terok Nor for the inevitable false vacuum, protecting the Iconian device in secret.
In 2437, General Worf, the las survivor of his crew arrives to find Molly, age 69, waiting for him since 2399. Archer kept her company through temporal project for 38 years. She tells Worf about the Obsidian Order plot and how, all these years later, they were the ones who destroyed Qo'nos and that she has the device to stop the false vacuum consuming everything before it gets too big. But the device must be activated from right next to the edge of it. Worf accepts his final mission to take the device from the girl he brought into this world in 'Disaster' who is now an old woman. Worf has his glorious death and the galaxy is saved.
In 3060, Archer sees that in the mid 25th century, with Qo'onos gone, the Klingon Empire remnant finally joins the Federation. He realizes that contrary to what Daniels instructed, he has become an active participant in his own timeline. Because he is Future Guy. His begins to do the Future-guy stuff we saw (and then some) and has a front row seat to eternity now, making sure the Federation achieves its destiny.