My favourite captain was Picard.
My least favourite was Janeway. She keeps talking about how the main priority is to get back to the Alpha Quadrant. But she keeps allowing small concerns to distract her. She's inconsistent when it comes to interpreting the Prime Directive. And she promoted B'ellana to head of engineering. I don't know about their time, but in the 21st century, we are taught from childhood that you don't hit people to solve your problems.