Ace Ventura. I just want him to do another package delivery intro. Even if I have to die to get it done.
briscoe and logan from the good years on law and order
monk and colombo although they might kill each other before they solved me
and the cold case squad …just the right amount of misfits to get things done
Scooby and the gang. Not Scrappy, I hate that little punk. Them meddlin’ teens!!
Takeshi Kovacs for me, thanks.
Harry Dresden. If I gotta be dead, I want half of Chicago, I mean, my hometown in flames/overrun by vampires/visited by living dinosaur skeletons.
His Grace, Sir Samuel Vimes, Duke of the Cities of Ankh and Morpork; with the able assistance of Captain Carrot Ironfoundersson.
John Constantine. Mostly because that means whoever killed me is going to get pissed beyond off by a master troll before getting their comeuppance.
William of Baskerville because it means that I have been dead for about 600 years. I should be over it all by now.
Inch High Private Eye. 
Really probably Claude Lebel. From my own experiences I’ve learned the best detectives are always tenacious as all hell.
I know who I wouldn’t want investigating:
Lt. Arthur Tragg and DA Hamilton Burger from Perry Mason. They had a terrible habit of arresting/charging the wrong people every week. HTF did that DA ever get re-elected? :eek:
Sheriff Roy Coffee from Bonanza was kind of a dumb ass too and locked up several innocent folks. He should have been booted from office as well!
Me too! It’s actually fun to hate him!
Encyclopedia Brown. Just because.
Them Hardy boys were kinda ‘dreamy’. If I was a teen who was murdered, send me the boys, please.
DCI Tom Barnaby or his brother. A long history of successful investigations.
Judge Dee. Djien Djieh Dee is the only detective I’ve ever read who used the term “murdered most folly,” so I’m sure he’d get to the bottom of the case, even if , as a T’ang dynasty Chinese official, he’d probably need some time to get up to speed in the modern world. (“Tao Gan, see if you can bypass the password on this website.”)
Adrian Monk.
(Not so sure about that captain he works for. He looks like the sort of guy that would throw you in a hole in his basement and say stuff like “It puts the lotion on it’s skin, or else it gets the hose again.”)
Bugs Meany did it!
Sherlock Hemlock
Another vote for Adrian Monk.
To quote Ed McBain: If I get murdered, do not call Jessica Fletcher. Call the cops.
Yes, but only if he’d been following the case in the colour supplements.
Otherwise Sherlock Holmes, if played by Jeremy Brett. Masterful, whip-smart and implacable.
What about a team up between Adrian Monk and Shawn Spencer? The investigation would be Hillarious, a few innocents would be fingered at first, but eventually the real killed will be brought to confess when Monk and Spencer are both telling theories at him in a grand finale.