Kirk and Sisko are the only two real choices here. Picard's more of a diplomat and Janeway 'Follows her gut'.

I'm surprised Sisko is beating Kirk in the war though. Sisko is good at war strategy, but he's not as much as a tactician. Strategy and tactics are two different things. Strategy is your overall approach to a large struggle, and tactics are specific maneuvers. The DS9 writers didn't focus as much on tactics as the TOS writers, there was nothing like The Corbomite Maneuver or Balance of Terror where Sisko has to take into account all the specifics of how an enemy might be thinking to trick them into making bad decisions.

As has been said Riker is overlooked.. he's easily one of the best officers Starfleet has and only recently got his own ship. He's very smart, quick wits and he rarely plays by the book and likes to improvise (to great success). That makes him a brilliant tactician and given a bit more time will easily fill the shoes of Picard and maybe make his own impression on Starfleet.

Click to expand...

Agreed. I would have voted for Riker.

Out of the current list my vote went to Kirk, with Sisko as a close second.

Click to expand...

TNG 'Rascals' Riker is a good tactician?

I would pick Archer. With an inferior ship, he outmatched klingons at least thrice, he found the solution to the xindi crisis, etc.

Kirk's achievements were far too often based on luck - because the writer said so (for example, star trek 11; TWOK Khan unable to understand space has 3 dimensions). And, in TWOK, he made a 'Rascals' worthy mistake - more than large enough to eliminate him from the competition.
Picard - beyond the Picard maneuver, he has little to show for; only the basics. A one trick pony does not a good tactician make.
Sisko mastered the fundamentals - but that's it. His achievements were based on the fire-power of his ship, not his tactics.
Janeway had technobabble and not much else.

And outsmarting klingons by clever tactics whenever the situation required, etc.
About the xindi crisis: Archer achieved a diplomatic/strategic success of that calibre, and he tricked Degra, gained access to the wormhole that lead to Degra by creative tactics, chose to teleport inside the xindi weapon, etc.

And not a single instance of tactical incompetence as uncompromising as Rascals or The wrath of Khan in all of Enterprise.
By comparison to Archer, Kirk and Riker were depicted as tactical ignoramuses.

Kirk's "bad tactics" moment in TWOK was not bad writing, IMO. It was part of the theme of the film: he was a guy who'd been out of the game for a long time at that point who, having successfully flown by the seat of his pants and gutted out the perils of overconfidence as a younger man, had to come face to face with the reality as a middle-aged man that you can't get away with that forever. It was probably some of the best work either Shatner or the writers ever did with that character.

Kirk is most certainly not "portrayed as a tactical ignoramus" prior to that. His tactical competence in "Balance of Terror" is better sold and flows more naturally from the script and the events than much of anything we see with later Captains, Archer included. You could tell that script was written by someone who understood and had probably experienced the naval warfare for which the episode's space warfare functioned as analogy.

Archer can be argued to have spent a lot of time winning by writers' contrivance (admittedly I can't speak to much of the Xindi arc -- the show had mostly lost me by then); the same was frequently true of Janeway and her confrontations with the Nerf Borg and the absurd Species 8472, and I do note that the biggest threat she really faced (the mad Krenim Annorax and his chrono-weaponry) she had to resort to a suicide attack to defeat.

On the other hand, Sisko also lost his ship. Picard as well (Stargazer, E-D doesn't count, he wasn't aboard). Janeway and Archer arrived at the end of the series with the original ships, and Kirk only lost his because he had a crew of 5 and lost the automation. Points off for Sisko and Picard there.

Click to expand...

Not sure I agree with your reasoning here. You're saying that Sisko's to blame for losing his ship to a direct hit from a weapon that the Federation wasn't even aware of is his fault, but it's not Kirk's fault his chief engineer didn't have enough common sense to prepare the ship for combat? And bear in mind that it was Kirk's choice to take only five people aboard Enterprise. Plot device or no, what he did was exceptionally risky and worked out only because he was up against commander who managed to be stupider than he was.

It was part of the theme of the film: he was a guy who'd been out of the game for a long time at that point who, having successfully flown by the seat of his pants and gutted out the perils of overconfidence as a younger man, had to come face to face with the reality as a middle-aged man that you can't get away with that forever.

Click to expand...

Kirk's leadership by arrogance approach is shown throughout the films. He finally stops in TUC because the stakes are extremely high (and his arrest prevents him from commanding the Enterprise until Spock is able to piece together the facts surrounding Gorkon's death).

Kirk's leadership by arrogance approach is shown throughout the films.

Click to expand...

Exactly why they should have stopped with TWOK, I always thought. The later films were more about trying to cash in on sentimentality than about convincingly developing the characters or setting. (And it would have shown far more guts to kill Spock and leave him dead. Nimoy could still have made his cameo cheddar in flashbacks and alternate reality episodes.)

Kirk's "bad tactics" moment in TWOK was not bad writing, IMO. It was part of the theme of the film: he was a guy who'd been out of the game for a long time at that point who, having successfully flown by the seat of his pants and gutted out the perils of overconfidence as a younger man, had to come face to face with the reality as a middle-aged man that you can't get away with that forever. It was probably some of the best work either Shatner or the writers ever did with that character.

Click to expand...

A person with medium IQ, with no experience and training whatsoever would not have made the mistake Kirk made in TWOK.
Kirk was utterly PATHETIC. A tactical ignoramus.

Kirk is most certainly not "portrayed as a tactical ignoramus" prior to that. His tactical competence in "Balance of Terror" is better sold and flows more naturally from the script and the events than much of anything we see with later Captains, Archer included. You could tell that script was written by someone who understood and had probably experienced the naval warfare for which the episode's space warfare functioned as analogy.

Click to expand...

That would be 'by someone who watched 'The enemy below''. The episode is practically a copy thereof.
And there are quite a few other episodes where Kirk won because he got lucky. The kind of luck that can make one win the lottery.