So people dunk on Star Trek: The Next Generation over their head of security: Lieutenant Commander Worf. He's a Klingon, a warrior people that were previously enemies of the United Federation of Planets.
I'm sure y'all know what I'm talking about, but to recap: Worf is head of security, and established as one of the toughest people on the ship- yet loses most fights he gets into to establish the strength of the one he's fighting. Folk call this The Worf Effect, and it's used all the time to make villains seem that much more powerful.
So why does this happen IN Star Trek? Well, Worf loses fights because he's built for politics. Not combat. Yeah, he's tougher than most of the humans on board, and his CULTURE requires him to be the first into a fight; but Worf started the show as an ADMINISTRATIVE officer, and among the security officers, he is still just that.
Worf's extensive knowledge of warfaring people, and their weapons; his inspiring ferocity that brings even seasoned Klingons to fervor; his space tactics! All these are what make up for Worf's (in comparison to non humans) frail constitution. He was never raised to be a warrior, but he was destined to be a general.
