Hard to really pass judgement on captains who appear in just one episode. We only see their worst side, none of their better sides.
If asking about which series captain
was worst, I'd say Janeway. Archer wasn't all that great earlier on, but I didn't think he made as many command mistakes as Janeway. She was also inconsistent in her priorities. It took a while for Archer to gain his footing, but once he had it, I think he turned out alright.