For me it’s:
Picard > Janeway > Kirk > Archer > Sisko
I’m not really up on the new stuff so I can’t comment too much abut new captains, but feel free to include them if that’s your thing.
Putting Archer above Sisko is a raw deal, are you just a huge ENT fan?
Oh yeah it’s 100% just a preference thing on my part. I grew up watching ENT with my Grandpa, he loved all versions of Trek but for some reason loved ENT the most, so Archer just has a special place in my heart. Sisko is awesome too though, no shade toward him at all.
Sisko > Picard > Freeman > Janeway > Kirk > Archer
Janeway would go later if Kirk wasn’t a character from the 60’s, for sure.
Wasn’t a fan of disco, but I wish I got more Captain Michelle Yeoh. Shame what they did with her in that series.
By height.
I’ll only include the captains (and Sisko) that I’ve seen:
Picard > Sisko > Freeman > Kirk > Janeway
Picard is the consummate captain to me. Perfect in most regards, at the cost of having no personal life.
Janeway just doesn’t do much right, in my book. She often has good intentions, but comes across as incompetent, reactionary, and inconsistent. Sometimes the Prime Directive matters. Sometimes she disturbs independent civilizations. Sometimes she’s spiritual. Sometimes she’s secular. Sometimes she’s pacifistic. Sometimes she commits murder. As opposed to all the other captains, I just don’t have a solid grasp on what her opinion of a situation will be.
Granted, being stuck in the Delta Quadrant was no picnic, and it’s possible I might have put any captain in such a position low on the list.