Best (or least terrible) Flag Officer
In Trek fandom, we often think about the badmirals. However, we never consider radmirals. With that in mind, who do you think is the best admiral? This includes commodores, vice admirals, rear admirals, etcetera.
I’m not counting main characters who got promoted after their main series e.g Picard, Kirk, Janeway, La Forge, etcetera.
Does it get any better than Dadmiral Vance?
Admiral April and Admiral Forrest are both solid options.
I think April did a really solid job of showing what a great but imperfect leader looks like in Ad Astra per Aspera.
Forrest was supportive and helpful. Willing to bend the rules to support his people rather than vice versa.
I find it kind of sad they haven't done anything in the 2290s-2350s era. I think it would be fun to have a series with April in monster maroon coming up on his second retirement in the late 2310s or early 2320s.
The IDW miniseries Picard's Academy was set in this era (aligning with previous canon of when Picard went to the Academy). I enjoyed it (checked it out from my local library), though probably half just because of Spock's outfit, honestly.
EDIT: April probably wouldn't be the primary focus. It would probably focus on a diplomatic ship or maybe even the Academy or civilians. It probably couldn't be too action-based, as we don't want to undermine this being one of the most peaceful eras in Federation history - I worry to do anything interesting, you'd have to pull Disco-style shenanigans again. No matter one's opinion on Disco, I feel like it would be kind of obnoxious to do another "this secretly happened and no one knows about it" series.
Links
I remember liking Admiral Haden
Admiral Micheal Burhnam fight me
Also Robert H. Justman