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.