You should (re)watch the finale of picard s01.Never Captain of the Enterprise. Only in alternate timeline and when Picard was Locutus. There was Rachel Garett Captain of the Enterprise C killed in Yesterday's Enterprise, and of course Harriman who was the idiot Captain who got Kirk killed on the Ent B maiden voyage. Left spacedock without a tractor beam, without photon torpedoes. Engines weren't even tested at warp power. Had no ships Nurse, Doctor or Engineer.
What's about Captain Christopher Pike?Depends on what you need. Diplomacy and clever tactics? Picard.
Space chess tournament? Punching a Gorn in the face? Kirk.
Somebody to cook a delicious meal? To violate every Star Trek directive in the same day and be able to live with it? Sisko.
To straight up murder people? Janeway.
To look good shirtless while rubbing decon gel on himself? Archer.
To come up with a different impressive hairstyle every season? Burnham.
This site provides links to other sites/services, and does not store any files