If it's a question of who I'd want to serve under in Starfleet, for example, it would have to be Kirk. If it's a question of who I'd want serving under me in Starfleet, it would definitely be Picard. If it's a question of who I'd want to go fishing and drink beer with, Archer has a pronounced advantage. If it's a question of who I'd go to if I had a moral conundrum I needed advice on, Picard and Sisko pull ahead. If it's a question of who I thought would be an engaging dinner companion and possible sex partner, Janeway is sharply in the lead. It's an expansive scenario.
Sisko is kind of hot. I could see him as my possible sex partner from all the men captains. Archer - maybe. Picard and Kirk do nothing for me in that way. And poor Harrison - I don't remember you dude.

But Janeway would be my captain to whom I would follow to no matter what end.