they can be police dectives private dectives or cozy amature types
id of made a poll but theres just too many …
Nero Wolfe
Columbo. I want my murderer to be stalked and driven crazy before he/she is nabbed.
Or Porfiry Petrovich in Crime and Punishment, on whom Columbo is based.
Batman.
Not that I think he’d be significantly better at figuring out who did me in than any others, but I know that if he got involved I at least went out in an interesting way.
Vlad Taltos. OK, he’s not exactly a detective, and he might not solve my murder, but he’s got friends who could bring me back.
(outside of D&D fiction, that’s the only setting I know of where resurrection magic is routine)
Tough call. A few options come to mind.
Frank Pembleton: Brilliant, dogged, and incorruptible. The man reads Greek! That would have to come in handy if I were snuffed.
Jim Rockford: He could probably get the killer, but even if he can’t my brothers would enjoy meeting him. My one brother built a muscle car out of an old Firebird, so he and Jim would have a lot to talk about.
Christopher Foyle: Mostly I think he’d be a calming influence. My wife would (I think) be beside herself if I got croaked. Mr. Foyle would put her at ease. Also, he’s entirely above reproach.
I think I’m going with… Foyle. Not only would he calm the situation down and get the killer, he’d do it with no violence whatsoever. And he’d look and sound perfect doing it.
I’d like a team-up of clouseau with Jessica Fletcher
You’d probably have been murdered just because Jessica was in town. :eek:
The hidden subtext/twist of Murder, She Wrote was that she was always the murderer, right? She would frame all these people, and each episode would show how she made it appear to the outside/law enforcement.
Harry “Snapper” Organs.
I’m kinda into Phryne Fisher at the moment. Plus I want to be murdered in Australia. And wear all those cool clothes, they are to die for.( heh)
Dan Simmons’ Joe Kurtz. I may be dead, but so will the perpetrators, at least one dirty cop, and probably a few innocent bystanders. I take being murdered very personally.
Either that or she was cursed to be a harbinger of death. 
C. Aguste Dupin
Patrick Jane from The Mentalist. He would walk in the room and solve everything in 5 minutes.
Hmmm. Peter Wimsey, Christopher Foyle, or Tom Barnaby? What a conundrum! I’m not sure I can make a choice.
NB: I have nothing against American detectectives, but there’s something terribly reassuring about these detectives. Somehow, you feel you’re in good hands.
Hieronymus “Harry” Bosch. The man’s relentless.
Sherlock Holmes.
Mike Hammer. He’d go all-out to solve my murder, break any law necessary and/or beat the shit out of anyone in his way. And it would be especially satisfying if he was killed just after publicly exposing my killer because I hate asshole detectives.