Box of Kittens
Banned
I vacillate because Picard is obviously the #2 best captain character, but he's more useful as a diplomat and military strategist, whereas I think Janeway, despite her writing inconsistencies, had more gumption and would be more likely to extricate you from a dire situation for which protocol is inadequate. Picard is Patton, Janeway is Dax from Paths of Glory.as long as it's not one she's arguably responsible for, like stranding one in the Delta Quadrant
Edit: Fuck Sisko. Not only the worst-acted captain in the series thanks to Avery Brooks' stiffness and inability to avoid hamminess (which was NOT a fit for Sisko like Shatner's subtler hamminess was a fit for Kirk), but his Space Jesus story sucked, his son sucked as a character and as a character motivation for him, his relationships with the crew were weak and largely underdeveloped, and his strategy for basically everything was "fly at it with a big-ass gun and hope things work out". How he got his little cult following I will never understand, because outside of "In the Pale Moonlight", "Far Beyond the Stars", and a few other episodes, he pretty consistently was not enjoyable to watch and had little dynamism as a commander.
A lot of Trek fans (myself included) consider DS9 to be the best Trek series so that's going to generate some goodwill for Sisko. He isn't my favorite of the captains but it's safe to say I like him better than you do. Honestly I think the Emissary thing was mostly fine until the Pah-Wraiths were introduced, but from then on yeah it's pretty bad.