He was an actor who absolutely sucked in ENT,
Bakula did not suck. He was miswritten.
I'm not sure a President Archer show is going to get anywhere close to the themes of Andor. Andor is very much a parable reflecting our world regarding totalitarian governments. Unless Archer is going to be a corrupt dictator or something, I'm not sure there's much story there, much less anything that can tread the same ground that Andor did.
The show can take inspiration from all of the US Presidents and events from their respective terms to characterize Archer and the era. I expect nothing less, tbh.
Maybe it intends to focus on Planetarist movements from Federation member worlds to achieve it's Andor themes? In other words, Terra Prime, but with teeth and some of them with rubber foreheads.
If it’s like TOS though, I wonder if the original allegory that Klingons and Romulans represent still applies?
The problem isn't the format. The problem is that anyone who actually has an interest in seeing the Romulan War will have a preconceived notion based on 50+ years of Star Trek as to how the war happened. And whatever they make will invariably not live up to those expectations.
What preconcieved notion?
The one from TOS, where primitive vessels with primitive atomic weapons fought with no quarter, no captives and no ship-to-ship visual communication. And treaty negotiation occured over subspace radio, and Romulans are remembered as warlike, cruel and treacherous.
That was later reframed by TNG where the Battle of Cheron was a humiliation that still stung the Romulans over 200 years later.
That was later reframed by DS9 as a conflict where civilians were targeted and the Romulans did not care about the conventions of war i.e. the Geneva Convention and the Geneva Protocol.
That was later reframed by VOY as an era where United Earth still used money, meaning financing the war might have been an issue (huh, sounds familiar).
That was later reframed by ENT where the Romulans had cloaks and telepathically controlled drone ships that could mimic any starship design, and Earth was part of a Coalition of Planets. And while the conflict was simply between Earth forces and Romulans forces in the beginning, it was a Human/Vulcan/Andorian/Tellarite alliance that won the war. And that in the prelude to the war, the Vulcan leadership were under the influence of deep cover Romulan operatives working towards reunification.
That was later reframed by ST’09 where all three Romulan dialects are indistinguishable from Vulcan, which calls back to something the comm officers of the ENT era - including Hoshi - should have noticed. And T’Pol, a former Ministry of Security operative, was the one that did the translating for Romulan first contact.
That was later reframed in BEY as a conflict that MACOs fought in and not all of them were happy with the post-war peace.
That was reframed in DIS with the 2155 Geneva Protocol barring bioweapons prior to the war.
That was reframed by PIC with the Qowat Milat existing, meaning they were an important faction on Romulus along with the Tal Shiar, the Romulan Navy, the War Plans Council, the Continuing Committee and the Romulan Senate. And the creation of the Mariposas Medical Movement, which existed for 400 years, had therefore to be active during the Romulan War period.
That was later reframed by the season one finale of SNW which left the door open to Earth’s side not being entirely innocent in the conflict.
I’m legitimately not sure what preconcieved notion you think the audience is going to have about the conflict, since the preconcieved notion is always evolving. And that's not even considering the Archer show, which could yet again reframe events.