In Tiberium Wars, GDI Commander Karrde finds Lieutenant Kirce James to be pretentious, self-important, and overly dramatic, which annoys him to no end. At the same time, she's able to whip up squadrons of Firehawks, an Ion Cannon, an entire division of GDI Marines, and a thousand Mammoth Tanks for him on short notice, so he doesn't complain at all when it comes to the results.
Dr. Kaminko from The Pokémon They Carried has a habit of naming his military hardware after Pokémon. Command lets him keep doing this because he's just that damn good at designing weapons.
Between his incompetence at the digimon card game, lack of experience, inability to make effective plans and shy nature, it's easy to write off Takato from the Tamers Forever Series as weak excuse for a Tamer. but his outward awkwardness masks an astonishing degree of comptetance.
Fridge Brilliance time: It is actually the above weaknesses that make him so dangerous, his lack of long term thinking is made up for by his impressive skill at using surprisingly effective Indy Ploy's, making him an unpredictable and dangerous opponent
The Ranma ½ fanfic Girl Days revealed that the Kuno family was full of Bunny Ears Lawyers, such as a WWII fighter pilot who wore a sailor fuku, or a samurai who fought with a live rabbit strapped to the top of his head. The current generation, though, are simply nuts.
Actually the current generation is pretty impressive. Tatewaki is a swordsman of such caliber and skill, he can use a bokken (bamboo training sword) and perform feats that surpass what is usually considered possible with a proper metal blade. Principal Kuno is a master of disguise, stealth, and using electric razors as weapons and has techniques that can cause weapons to split like banana peels. Kodachi is a mistress of poisons and rhythmic gymnastics combat. Despite delusions of grandeur, Tatewaki is actually considered quite handsome, and is very skilled in romantic gestures, just a bit misguided in who he directs them towards and oblivious to certain facts (mainly that female and male Ranma are the same person, despite Ranma transforming in front of him, both directions, on multiple occasions, including at least once while he was embracing female Ranma). Kodachi is completely psycho crazy, but she is actually pretty tactically skilled, and able to hold her own in fights with Akane, Shampoo, and Ukyo... sometimes simultaneously.
ALL of the scientists in the Bleach fanfic Project Tatterdemalion fall under this trope: Urahara, Yoruichi, Tessai, Isshin, Masaki. The only reason they're still employed after all their insane prank wars, bizarre personal quirks, and failure to obey military protocol is that their scientific work is unimpeachable.
Shunsui does a much better job of keeping it under wraps but he's pretty eccentric for a high-ranking security officer.