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.