Worf - Klingon, but not exactly great backup in a fight
Yeah, yeah. He is Klingon, a warrior, blah, blah, blah. But d'you actually remember TNG? A typical scene would go something like <Worf snarls> <Worf leaps into the fray> <Worf gets his butt kicked> Somebody (usually Beverly Crusher) bails him out Mind you, they did make Beverly Crusher quite the dab hand at command (and, well, pretty much everything), but man, did they ever make Worf into a wuss - as evidenced from this video of Worf's greatest hits (or hits on Worf?)