Still not in, but if we go for movies :
- "Without a Clue" and "Murder by Death" are two magnificent parodies of sleuthing tales. "Without a Clue" is less straightforward absurd, and even though a Holmes parody in which Holmes (Michael Caine, brilliant) is a dimwit and Watson (Ben Kingsley, brilliant) is the actual brain behind the investingations, it is still, for some reason, the most faithful adaptation in my eyes : something just feels very right in the atmosphere, the acting, etc...
- As I like the cliché of recluse detectives, one of my favorite movies is "The Zero Effect" with Ben Stiller, Bill Pullman and Kim 'Brazil' Dickens. It takes the cliché of high-detective-skills-low-social-skills to an extreme.
Also, one of the best detective miniseries I've seen has supernatural elements : it's a japanese animated series (or a comics) called "deathnote" and, if you haven't heard of it, is about a typically atypical genius recluse detective trying to outsmart a very clever (increasingly sociopathic) vigilante with a huge god complex and a magical notebook that kills at a distance whoever's name is being written in it. It's a thrilling, complex story, with lots of complicated Dupin-like reasonings ("if we do that, he'll think this, and do this, for us to think that, but we'll do that, to for him to do this, and, oh, damn, he had anticipated that").