In pretty much everywhere but America, Tintin is one of the most widely-recognized and beloved characters ever. A Belgian adventurer, reporter, and detective, all rolled into one, Tintin's been running around and getting into occasionally racist hijinks since the 20s. Tintin himself isn't very exciting - he's honest and nice and all those dull things, but he brings along some fun compatriots, like drunken sea captain pal Captain Haddock and his adorable dog Snowy. Tintin's having a bit of a renaissance at the moment, with the recent release of an uncanny valley motion capture film that will certainly delight and terrify children for ages.
Marketed as The OCD PD, Monk delivered just that - Tony Shaloub's obsessive-compulsive disorder gave him incredible powers of deduction, noticing things that no one else would. But his ability also had some drawbacks - he saw stuff no one else would care about, including germs everywhere, dirt, grime, and general chaotic disorder throughout the universe. With his interchangeable blonde assistant and police chief Buffalo Bill, Monk was a great detective because almost everything terrified him completely, yet he soldiered on. Although really someone should have told him to stop cleaning up blood at crime scenes before season 8.
Fox Mulder - or "Spooky" Mulder as he was called by his super-uncreative co-workers on The X-Files - was the weird guy in the office, who believed in aliens and monsters and every other type of paranormal activity you could imagine (and he was right to, since literally all of it and more was true). Paired up with the skeptic Dr. Scully, they solved bizarre cases that you'd think the FBI wouldn't really bother with. Ultimately, they uncovered enormous, globe-spanning conspiracies involving an alien invasion, some black goo, bees, hybrids, and a cigarette-smoking man. And despite discovering these apocalyptic revelations, there are apparently 7 detectives better than this?
Inspector Gadget is more or less Inspector Clouseau Mixed With RoboCop, a bumbling idiot with robot parts going throughout most of his body, who would try to defeat a clawed-weirdo with a cat fetish while his niece did all the actual legwork. The bigger question is why was this guy turned into a cyborg? This guy's a walking arsenal of death, but is constantly being outwitted by his tween niece and a dog. Let's just hope he never tried "Go-go-gadget gatling gun."
And here he is - the true king of incompetent-detective-who-solves-cases-anyhow: Leslie Nielsen's Frank Drebin, of Police Squad! and the Naked Gun films. As part of one of the funniest film franchises to ever feature OJ Simpson as a main character, Frank Drebin would frequently switch between being an utter genius and a complete moron. Regardless, he managed to stop Ricardo Montalban, Robert Goulet, and Fred Ward's evil plots, while occasionally running into Weird Al Yankovic.