A return to the Temporal Cold War
Speaking of Captain Johnathan Archer, he was the focal point of Star Trek: Enterprise, a series that introduced the idea of the Temporal Cold War. A time-travel war against a called the Suliban, an alien race that is attempting to rewrite time. Archer had several encounters with them throughout the show, and while the Temporal Cold War storyline always existed in the franchise, it did take a back seat to the Xindi storylines.
Star Trek’s Discovery and Picard have seemingly opened the door to a return of the Temporal Cold War, with Screenrant writing;
"This is why it’s very possible the events of Star Trek: Picard season 2 could set the stage for the Temporal Wars that will ultimately reach back to Star Trek: Enterprise’s 22nd century, Star Trek: Discovery’s distant future, and even into the Kelvin timeline of J.J. Abrams’ Star Trek movies."
Like the previous entry, the idea of a massive crossover, and involvement of the Kevlin universe are again being brought into the conversation thanks in part to Q’s involvement. Whether or not that actually happens is anyone’s guess. Frankly, a return to the Temporal Cold War would make a lot of sense, but only if it’s done in its own series. Bringing in several characters from across the timelines would be a great idea for a show.
You could have Scott Bakula’s Archer lead a group that includes Zoey Saldana’s Uhura, Karl Urban’s Bones, Garrett Wang’s Henry Kim, maybe someone from Discovery, like the real Gabriel Lorca, and maybe someone from Picard, like Isa Briones’ Soji (or Dahj, cus again, time travel).