The sequel to Uncharted gives us Harry Flynn, who pulls a Face Heel Turn early on, and demonstrates an outstanding lack of common sense more or less continuously, as well as deduction and decryption chops that would not shame a watermelon (although it's a bit unfair when the competition is Nate Drake). Sadly for him, the Big Bad is also a Bad Boss.

Scorponok fits this trope to a T. He was really kind of an idiot; really the only things he had to his name were his loyalty and some surprising talents with inventing (though when his inventions went wrong, they went wrong.) To be fair, his loyalty certainly was a commodity what with the likes of Terrorsaur and Tarantulas on board.