Chance Purdue has to be the funniest PI on the planet (author: Ross H. Spencer).
Bernie Rhodenbarr (Lawrence Block's Burglar Who... series) haven't been mentioned yet. Shame on the lot of you!
Anthony Boucher wrote some great locked room mysteries. Can't remember the names of the protagonists, though
