I chose Picard because he was my first impulse, but Sisko is a close second.
Picard had a ship of about 1000 people including children and other civilians, yet he managed to have adventures while providing a safe environment for his people simultaneously. He may not have been the most "friendly" or "approachable", but he had a very large crew and he did his job well.
Sisko had a lot on his plate with the Dominion war at his doorstep and all that went with it, yet he rose to the challenge and proved himself worthy of the task. I respect him enough to want to work under him.