So does Dudley Do-Right. 
Yeah…but with Dudley Do-Right it is always the same man-Snidely Whiplash.
Poirot.
Dexter Morgan. I want the bastard who did me in to die brutally.
Yet he never communicated his doubts to this “other person”.
Strange, that.
Might suggest that they weren’t so different after all.
Most of the murders happened in Cabot Cove. Maybe it was something in the water that turned regular people into psychotic murderers.
There are a lot of good detectives still on the board. Lenny Brisco from Law & Order, Kay Howard & Meldrick Lewis from Homicide: Life on the Street, Benton Frasier of the RCMP currently serving as at the Canadian consulate in Chicago and his friend, Detective Ray Vechio of the Chicago PD, Detective Mick Belker of wherever the heck Hill Street Blues was set, Det. Virgil Tubbs of Sparta MS, Det. Jane Rizzoli of the Boston PD, Lt. Abbie Mills of Sleepy Hollow, Deputy Barney Fife of Mayberry, etc etc etc.
I’m going with the Mountie in Chicago and his friend, Frasier & Vechio.
Doyle was very good at separating his fictional detective (and some other creations) from his own beliefs. Holmes very notably dismissed supernatural explanations in The Case of the Sussex Vampire and in the novel The Hound of the Baskervilles.
He even spared his Professor Challenger (central figure of not only The Lost World, but of The Poison Belt, The Land of Mist, and a couple of short stories. When he DID go embarrassingly off the deep end into the supernatural in The Maracot Deep, he invented a new professor, Professor Maracot, to be his mouthpiece.
Any particular reason you left out Dirk Gently?
Just an addition to my hope that Adrian Monk investigates my murder. I also want Dr. Julia Ogden to perform my autopsy.
I’d like Dr Al Robbins on CSI. I wouldn’t mind Gil Grissom investigating my murder, either.
Magnum, because it would mean I was in Hawaii.
Inspector Wexford.
I wouldn’t go with the Barnaby cousins, because I’m not going anywhere NEAR Midsomer. Their murder rate is astronomical!
It’s as high as Cabot Cove, Maine, and Kembleford, UK. 
Since I’m a vengeful sort, I’d want the investigator into my murder to be Jack Reacher. He might not build an airtight case, but he’s fully capable of unleashing major whoop-ass on the perpetrator(s).
Second choice would be Matt Scudder, who isn’t above killing the bad guys (or framing someone for a serious crime if he can’t get the goods on them for a specific murder).
I’ll take Reacher if Machete isn’t available… good choice.
Again, my selection of Machete isn’t just about solving my murder. It’s about what comes after. 
Same here. Preferably Lewis so my grieving* wife could meet Hathaway.
- Or is she???..
I’m kinda leaning toward Jim Qwilleran and his 2 Siamese cats, Koko and Yum-Yum. Just because I’m pretty sure the cats do all the detecting.
I can just see the headlines:
“MURDER OF BECKDAWREK case solved
by Two SIAMESE CATS”
Not her own 2. They didn’t really give a
shit whether she was dead or not!
John Luther.
My first thought was Lord Peter Wimsey. But now that I’ve read the thread, I think Christopher Foyle, Lennie Briscoe and Sherlock Holmes in the person of Benedict Cumberbatch would all be worthy investigators.