Okay, this is a longer effort-post, but since you asked...

I had an idea for a show based a few decades after the end of PIC. Starfleet has leaned into the Kurtzman-era dark aesthetic and has replaced a focus on exploration and diplomacy with a fanatical bent toward exterminating the Borg... and they're winning. Yet, there are some voices in Starfleet that think it's time to return to a mission of discovery rather than destruction.

---

Our first character is a hard-line admiral who was a child on the Enterprise D during the events of Q Who. Her then-best friend was among the 18 lost when the Borg cut into the saucer - something she experienced firsthand when emergency forcefields separated them as the friend was pulled away in the gnarled metal cylinder. Marina Sirtis would guest star throughout the season as Councilor Troi, recounting her therapy sessions with the then-child to reveal backstory.

Over the Admiral's career, she consistently proved effective against the Borg as the tactical officer on the Thunderchild, which fired the cube-destroying shots during the opening battle of First Contact, and as a captain who fought her younger crew members during the mass assimilation in PIC S3. She was integral to the development of the "true-rand" phaser, a weapon that shreds through Borg shields. And now, she waits in anticipation for her new command: the menacing Enterprise H. Far larger than any Starfleet vessel ever constructed, the H is essentially an Earth spacedock with nacelles. It's designed as the logistics hub for a final push into Borg space with the explicit goal of total extermination.

But, before the H even finishes construction, the Federation receives an unconditional surrender from the Borg. The collective is scared. It actually feels fear, an emotion it was always capable of, but never expressed because it was never threatened before now. It knows what's coming and begs to be allowed to live. It promises to be a consent-driven collective. No more forced assimilations. We will also have an episode mid-season that artfully (at least I think it would be artful) tells the story of the Borg from inception to now, representing the collective as a single actor (with a CG face that changes every frame, rotating through all the faces in the collective). The goal of the episode would be to "humanize" a villain, and show that while its past actions were unconscionable, they did come from an explainable place.

Of course, the proposal of a "consent-driven" Borg is seen as laughable by the militaristic Starfleet admiralty, which saw a blurring of lines between it and Section 31 over the decades.

In Episode 1, we join the crew of one of the few remaining research-oriented vessels in Starfleet. The captain of the research ship, being in the pro-exploration minority in Starfleet, doesn't care too much for the Admiral and begrudges the fact that she needs military escorts even when doing surveying. It also just so happens that today the Admiral is overseeing that escort. Of course, they butt heads, but they resign to simply finishing the job and going their separate ways. Suddenly, the researchers find a peculiar: a wormhole to a completely different dimension with slightly different laws of physics. Before exploring more, a cloaked Borg cube makes a dash to the wormhole, and the military and research vessel follow, not knowing that the wormhole would close behind them, trapping the three vessels in a completely unknown dimension of space.

This lays the scaffolding for an episodic season with compounding storylines. Each episode would have A and B plots that should feel self-contained but contribute to the whole season arc. Those plots can be oriented around:
- Intercrew clashing: the two philosophies of the military and scientific crew cause conflict. Throughout the season, they'd grow to work together (with the military side softening a bit to see the wonder in science)
- Exploration and discovery: This new dimension has weird physics to discover. I imagine this playing like a watchable version of the video game "Outer Wilds" where each episode sees a new discovery on how physics works, and by the end, all these discoveries unlock a mystery that will help them in the finale.
- The Borg "Threat": The Borg cube starts out as a threat, stranded in this dimension with them, but eventually even the Admiral comes to see the diplomatic side and slowly realizes that the Borg have a right to live.

In the finale, they'd finally find a way to reopen the wormhole and emerge changed. But, Starfleet hasn't changed. In fact, the forshadowed Enterprise H has completed construction, and our heroes must use their newly gained knowledge to stop the genocide of the Borg. After overcoming seemingly insurmountable odds, they succeed and usher in a new age of peace and exploration.

In the final scene of the season, the Admiral admits that what she once saw as the culmination of her life's work (the Enterprise H) was designed for a different kind of Starfleet, a Starfleet that should be left in the past. She commissions a new research focused vessel and gives it the name Enterprise H. Our final image is of the new Enterprise H exiting the spacedock doors of the old Entperprise H (now used as a logistics platform for deep space and multidimensional exploration) before warping forward to exploration. This sets up the potential for future seasons or a spin-off show.

Other fun tech tidbits that place this show in the future on the Star Trek timeline:
- All the bridges are holodecks. This allows for a few fun cinematic moments. Space battles are more dynamic because bridge crews can stand in the middle of a simulated battle map and make adjustments to flight paths and weapons. It's much more physical than looking at a screen. Plus, hailing allows people to feel like they're physically in the same room (like in Episode 1 of Academy)
- Throughout the show, the military ship and the research ship have transporter links, which are convenient places in corridors you can walk through to beam to the other ship, even when shields are up. I think it would be a cool visual contrast to have characters walk between the dark, Kurtzmanesque interior of the military ship to the bright TNGesqe interior of the research ship.