I'm sure this has been done a thousand times before but I can't find a thread on it.
For me it's a toss up between Kirk and Picard. Very different characters and captains but equally great. Kirk being a man of action appeals to me slightly more. His fight scenes are legendary, especially with the Gorn
Sisko got better as time went on. By Season 4 I think he was comfortably in 3rd place.
Janeway was a mess. She didn't seem to know her mind a minute. Because of how she's acted and occasionally how she's written I still sort of like her but she was a dreadful captain.
Archer was a plank of wood. Scott Bakula was great in the fantastic Quantum Leap but he was so bland in Enterprise. I didn't think much of him as captain. Trip would have been better.
I included Pike since he was almost the regular captain of the original series. Not much to say about him really as he only had one episode under his belt.
For me it's a toss up between Kirk and Picard. Very different characters and captains but equally great. Kirk being a man of action appeals to me slightly more. His fight scenes are legendary, especially with the Gorn

Sisko got better as time went on. By Season 4 I think he was comfortably in 3rd place.
Janeway was a mess. She didn't seem to know her mind a minute. Because of how she's acted and occasionally how she's written I still sort of like her but she was a dreadful captain.
Archer was a plank of wood. Scott Bakula was great in the fantastic Quantum Leap but he was so bland in Enterprise. I didn't think much of him as captain. Trip would have been better.
I included Pike since he was almost the regular captain of the original series. Not much to say about him really as he only had one episode under his belt.