The greatest challenges a detective faces aren't always a devious criminal or a really tough case — all those are a cakewalk compared to managing their personal life.
The genius ones are nerds
with trouble getting along with people or worse, have social or personality disorders. The hard-working ones are workaholics who let their family relationships slide
because they're never home. The overworked and nervous ones dabble in drugs and court substance addictions (or blood.
) The Film Noir
detective and his descendants have terrible luck with women, who either end up dead
, broken or distant; if he has a wife he may be cheating on her
. And gods help him and his friends if some of the bad guys or associates that they helped put in the clink come back to haunt him.
In short, it's rare to have a detective as a main character in a dramatic story and have them not
have at least one serious character flaw that's tangential to them actually working cases.
Not to be confused with Clueless Detective
See Also: Achilles' Heel
, Bunny-Ears Lawyer
, and Why Did It Have to Be Snakes?
. Related to Dysfunction Junction
open/close all folders
Anime and Manga
- Monster: Lunge's obsession with Tenma verges on psychosis and ruins both his personal and professional life, Richard Braun is recovering alcoholic and Jan Suk is naive and trusting (which is a HUGE defect in a series with people with split personalities and/or false names, violent psychopaths and shady ex-intelligence operatives all out to try and control Johan, bystanders be damned).
- MPD Psycho: The story is about Tokyo police inspector Yosuke Kobayashi, who receives a box at work containing his still-living but dismembered girlfriend. The gruesome sight, along with the culprit's insane unrepentance when captured, causes Kobayashi to snap and develop Dissociated Identity Disorder (split personalities), which becomes the focus of the story.
- Death Note: All of the Wammy's House detectives have problems. For a start, they're all orphans. Now for the individual issues: L's social skills are awful and he has no friends, Mello has a violent inferiority complex, and Near's ability to live everyday life is ranked by the supplementary 'How To Read' material as being almost zero.
- Ken Edmundo in Heat Guy J
- Shinichi Kudo is a fantastic detective, but he's extraordinarily socially inept in many areas, particularly in picking up blindingly obvious cues that Ran is getting exasperated with his nonstop Holmes trivia (and that she may be flirting with him). Oh, and he's spent most of the series shrunk to the body of a child, which lends itself to more than a few hardships.
- The extreme personality of Batman is the real one while "Bruce Wayne" is merely a facade.
- An episode of Batman Beyond confirmed this is true in the Dinniverse as well. A villain tries to manipulate Bruce Wayne by using subsonics to simulate his subconscious. It is revealed that this didn't work because the "subconscious" referred to itself as Bruce. Apparently, this isn't the name Mr. Wayne calls himself in his own head and he realized it was a fake immediately.
- As of the One Year Later storyline, Bruce realizes how fundamentally screwed up this is and is trying to strike more of a balance between his two lives.
- This interpretation has only been valid since the mid-80s (i.e., more or less since The Dark Knight Returns). Prior to that, Bruce Wayne was his "real" identity.
- Nick Kelly, in the British comic The Topper. His strip was originally called Send For Kelly and his assistant Cedric, but was later retitled Kelly, the Defective Detective. Ran from the 1950s to the early 1990s.
- Sam & Max: Freelance Police: One of the many detective conventions parodied. Both are totally insane, but as a Heroic Comedic Sociopath team rather than as The Woobie. That said, they'll sometimes dip into this reasoning to justify their ridiculous actions.
- Fillmore Press in Bedlam is The Profiler, possessing a very deep understanding of the criminally insane mind. This is due to the fact that he himself was once a crazed killer, now cured after a long stay in a psychiatric hospital. However, even with his medication, he mostly acts like an overgrown autistic child.
- Franchise/Tintin: Thompson & Thomson these two couldn't detective their way out of a cardboard box.
- The Bone Collector: Lincoln Rhyme is paralysed following an accident yet continues to help solve crimes despite being bedridden. He has to be one of the most extreme examples: he can only move his head and one finger, and the only body function he is in control over is his breathing!
- Ellis Fielding in Loose Cannons has a split personality disorder.
- Hellraiser Inferno: Det Joseph Thorne is a workaholic additionally obsessed with mysteries, puzzles and games of all types. When he does have time to go home to his beloved wife and kids, he often spends that time with a prostitute.
- In The Alphabet Killer, Detective Paige always knew that she was different from her colleagues in her uncanny obsessive tendencies. She did not know, however, that these were the first signs of a mental illness that would lead to a psychotic break.
- In Zodiac, David Toschi is a fairly competent detective despite his talent for self-promotion and unhealthy obsession with Animal Crackers.
- In Who Framed Roger Rabbit, detective Eddie Valiant not only has an alcohol problem, but also has trouble with his relationship and is traumatized by his brother's death.
- The Gauntlet: Ben Shockley, Clint Eastwood's Deconstruction of Dirty Harry, is a heavy drinker and a Punch Clock Hero, with even fewer friends than the usual Cowboy Cop.
- Robert Downey, Jr. plays Sherlock Holmes this way even more than his written characterization. He is unable to "turn off" his Sherlock Scan, which may play a part in his addictions, and he is an extreme narcissist.
- Downplayed in Sherlock Holmes, who, in addition to being extremely cold and distant to most who knew him (it's no surprise he only has one real friend), had morphine and cocaine addictions that plagued him until Watson helped him get over them. However, the drug use stops when he takes on an interesting case, his eccentricities are only a small part of the story, and never get in his way while solving a crime. (The legacy of the character is perhaps a bit different— his personality defects are severely played up in many of the many adaptations to be found in the Film and Live-Action TV sections.)
- Literary adaptations too— In Michael Kurland's Moriarty series, Sherlock Holmes is portrayed as a bit more defective than in the original series, especially when it comes to his ability to think rationally about what Moriarty says and does.
- Nero Wolfe has the flaws of a considerable ego, a touch of agoraphobia (or simply a marked preference for staying at home), and his considerable girth (he is said to weigh "a seventh of a ton," approximately 286 lbs making him "morbidly obese" in the era in which the story was originally written, but hardly noteworthy today). Wolfe is shown to be able to have the will to overcome all these flaws when solving crime.
- Hercule Poirot: Poirot suffers from a minor case of OCD; the books go into more detail regarding his love of neatness than the television series — the first novel actually has him finding a vital clue as a result of rearranging the decorations on a mantelpiece.
- Vicki Nelson in Tanya Huff's Blood Books series. Had to quit the police force after developing a degenerative disease in her eyes, and became a PI who teams with a vampire because she can't see at night.
- The Yiddish Policemens Union: Meyer Landsman of Michael Chabon's novel is an alcoholic mess, has massive problems about family, guilt, religion, and chess, and is a hard-as-nails Determinator to boot.
- 'The Little Sleep'': Mark Genevich is narcoleptic and sometimes has hypnogogic hallucinations. Which is just a tiny bit inconvenient for a P.I.
- Many members of Michael Slade's "Special X," the fictional RCMP homicide unit from Ghoul and other novels, have taken a pounding over the years. Zinc Chandler in particular fits this trope, having developed epilepsy after narrowly surviving being shot in the head.
- Parodied in The Areas of My Expertise with a list of ridiculous detectives, including one who was his own worst enemy, one who was a Satanist, and one who never got out of his bathtub.
- Kurt Wallander: Kurt has diabetes, an alcohol problem which is not quite alcoholism but always verges on it, no contact with his ex-wife, bad contact with his father and daughter, no friends, etcetera etcetera. (Fridge Brilliance: Shouldn't a limited third person narrative describe an actual alcoholic as a borderline alcoholic?) And in the end, for all his troubles, he gets to retire... with Alzheimers.
- Jack Vincennes in L.A. Confidential is a capable enough detective but he's also a recovering alcoholic and drug addict who once shot two innocent people under the influence. In something of a subversion, getting back on the wagon does not make him a superb crime solver but pretty much screws his life up.
- Charles Todd's Inspector Rutledge, a shell-shocked WWI veteran who constantly hallucinates the ghost of a soldier he had to execute.
- The Well of Lost Plots: Subverted. Thursday is hiding out in a very bad police procedural novel, and the protagonist, DI Spratt, is forced to have a dysfunctional family on the point of breaking up because the novel is so cliched. Thursday helps him out by making him subtly change the narrative. It turns out that the dreadful police procedural is an poor early draft of another Fforde novel, and when that novel is published Spratt and his family have become perfectly functional.
- Commander Sam Vimes: When we first meet him in Guards! Guards!, he's an miserable, misanthropic alcoholic, in charge of one of the most ragtag police forces that fiction has ever seen. The reader first meets him in a literal gutter, piss-drunk. (It is suggested later that he didn't start out like this, but had his idealism ground out of him by 25 years on Ankh-Morpork's (very) mean streets.) The arrival of Carrot, his first encounter with his future wife Sybil and the defeat of the dragon start him on his way back up towards at, the very least, Knight in Sour Armor-hood. But it takes until the third book for him to be completely on the wagon, and a full seven to give him a wife, a working police force, and a beloved son. And, after all of that, he's still more of a Jerk with a Heart of Gold than your classic hero.
- And he still has the small matter of the demon-brand of the Summoning Dark on his arm to worry about occasionally.
- Captain Carrot Ironfoundersson is a grand subversion. He's walking perfection scented by soap. Yet everyone still likes him. He's got loving adoptive parents, an alternative but healthy, relationship with his girlfriend Angua, and helps keep relative order in Ankh-Morpork by the power of his sheer Carrot-ness.
- Angua herself is a better example, being a werewolf aware of her own species' propensity to mayhem and mental disturbances. Her psychopathic brother Wolfgang killed her sister and drove her other brother away from the family, and conspired with their mother to dominate Uberwald politics. Her fellow police can't help but carry silver in her presence, and even the city's resident undead are unfriendly to her because she's a cop.
- Douglas Adam's Dirk Gently is a highly competent detective who can piece together the most bizarre cases thanks to his holistic approach (as advertized by his 'Holistic Detective Agency' operation) though his personal life is a complete mess. For one thing, he hasn't opened his fridge in years and is engaged in a daring game of chicken with his cleaning lady who are both trying to trick the other into opening it first.
- An Alternative Character Interpretation is that Dirk is accidentally a highly competent detective, having created the entire notion of Holistic Detection in order to provide an explanation for submitting all-encompassing expense reports to his clients. He always solves the case, but his motivation is less about Justice, Closure, or Solving The Unsolvable, and more along the lines of "I want to do whatever I like, and get someone else to pay for it all." The TV Adaptation of the first book leaned very heavily in this direction, and gave Dirk some interesting new flaws. In particular, he was quite willing to hypnotize his apparent best friend into "investing" in the agency, said investment being promptly used to give himself a nice holiday.
- The Dresden Files:
- Harry Dresden has serious woman troubles. His first love is Mind Raped into betraying him in the backstory (and he doesn't find out it was due to Mind Rape until later in the series), and she pretends to be dead so he thinks he killed her. His second love is half turned into a vampire and forever suffers serious temptation - which he blames himself for. His third love turns out to have been mind controlled into being with him, and doesn't actually have any (romantic) feelings for him. And to top it all off his second love comes back in Changes and reveals that she had his kid without telling him. And then he's forced to kill her.
- Harry also develops severe pyrophobia after a close-range encounter with a flamethrower. In the following books, a lot of bad guys suddenly start using fire-based attacks. In Turn Coat, his encounter with an Eldritch Abomination incapacitates him completely whenever he so much as remembers bits of it. Jim Butcher does love to torture Harry.
- In the short story Death Rides the Elevator by Lois H. Gresh and Robert Weinberg, private detective Penelope Peters suffers from severe agoraphobia and is completely unable to leave her house.
- Gorky Park: Arkady Renko is a workaholic, very cynical (especially in regards towards the Communist Party and their declarations), and is a chain smoker. Guess which one gets him in trouble while working a triple-homicide case in Moscow in the 1980's. His wife is having an affair behind his back, and while that is going on, he falls in love with a political dissident who is involved in the murder case he is investigating.
- Lord Peter Wimsey has a lot of advantages, being a filthy rich aristocrat, but he also has a severe case of shell-shock (post-traumatic stress disorder, in modern terms).
- The Millennium Trilogy features Lisbeth Salander. She's small, antisocial, and has an Ambiguous Disorder.
- Peter Robinson's Inspector Alan Banks had a close childhood friend who disappeared, which haunted him for years; he eventually learned that his friend was murdered. His marriage failed and he's since had a series of complicated relationships with women. He's not an alcoholic, but he's been known to drink excessively on occasion and has gotten into a few fistfights while under the influence. His older brother was murdered, and in Robinson's most recent novel, his daughter got involved with a very bad boy who abused her and involved her in criminal activities.
- Harry Hole is severely alcoholic, prone to bouts of depression, and has major issues with relationships. He's also probably the sharpest detective on the Oslo police force, which is likely the only reason he still has his job.
- The title character of the Mediochre Q Seth Series has some, uh, issues. In fairness, so would you if you were trapped in a teenage body for ever.
- Detective Ryan of the Temperance Brennan novels (the basis for Bones) is divorced and still dealing with the discovery that he has a daughter by his ex wife and she's addicted to drugs and always in trouble.
- Main character Temperance Brennan (not to be confused with the TV series version) was an alcoholic in the past and is divorced from her cheating husband. Worse, she's always getting targeted by the killers she and Ryan chase.
- Helen Walsh in Marian Keyes' novel The Mystery of Mercy Close is chronically depressed. She's contemplated attempting suicide so many times that in one Imagine Spot of hers, she leaves a polite note that she committed suicide for whoever finds her body.
- Dr. Wendall Urth from The Singing Bell and other Isaac Asimov stories. He won't go anywhere he can't walk, and the mere mention of an airplane trip sends him scuttling from the room in fear. But he caught a murderer with no apparent evidence, recognized the location of important coordinates, note and figures out how to possibly retrieve important data thought lost.note
- Elizabeth Zelvin's Bruce Kohler is a recovering alcoholic. In this case that means that he woke up in a Bowery detox after a Christmas Eve blackout and saw one of his fellow patients die painfully a few days later. One reason he invetigates crimes is to distract from the boredom of sobriety.
- Nick Moss, the gumshoe of City of Devils is not an impressive man.
- Chris Black, of the League Of Magi novella "Coldheart" is a paranoid schizophrenic who can't even be certain the disappearance he's investigating is even happening.
Live Action TV
- Monk: The central character is the Trope Namer. He's a detective with obsessive–compulsive disorder. (Occasionally other characters and the promos even call him "the Defective Detective"). In the Russian dub, the name of the show is The Defective Detective!
- To a lesser extent, Captain Stottlemeyer counts. He has had two failed marriages (his first one actually only lasted a week! The other lasted 20 years and fell apart in the normal way). His next serious girlfriend is Linda Fusco, who Monk and Natalie expose in "Mr. Monk and the Bad Girlfriend" as having shot and killed her business partner.
- In the novel Mr. Monk and the Blue Flu, Lee Goldberg takes this Up to Eleven by having Monk during the titular Blue Flu working with three other detectives who have been involuntarily retired — each bonkers in a different way, and each with his or her minder. Natalie finds that their issues make Monk look normal. It should be noted that the mayor hired these four (Monk and the other three detectives) because of the labor shortage. And Natalie only needs to see one look at Monk to realize that the reason the mayor wants him to lead them is because even if he doesn't know them, he probably understands their troubles better than anyone else (besides their shrinks).
- They are Jack Wyatt, a very Dirty Harry like detective with anger management problems who was fired after the city lost a number of lawsuits caused by his tactics. His anger management counselor Arnie is his helper. Wyatt uses these effectively in that we see him lead a SWAT team raid to capture a serial killer without any difficulty.
- Then there's Cynthia Chow, a paranoid schizophrenic who sees conspiracy theories everywhere, who was relieved of her badge due to her condition getting pretty severe. Her "curse" becomes a "gift" in that it allows her to tie together seemingly unrelated cases. Jasper Perry, her shrink, is her helper.
- Also, there is Frank Porter, an ex-detective helped by his granddaughter Sparrow, who has senility issues.
- As mentioned under Literature, this aspect of Sherlock Holmes is often exaggerated in adaptation:
- In Elementary, he is a socially inept recovering drug addict with serious Daddy Issues.
- In Sherlock, he's an outright (self professed!) high-functioning sociopath. He is also portrayed as literally addicted to the intellectual stimulation of his detective work— in the first episode, he engages in a likely-suicidal action just because he needs to know if a deduction is right.
- Ironside. The title is a reference to his wheelchair and his name, Robert Ironside.
- Frank Pembleton and Tim Bayliss on Homicide Life On The Street come to mind. Pembleton's single-minded drive for justice leads him to renounce his Catholic faith and leave his wife, at least for a while, and he has a stroke that sidelines him for much of the fifth season. Bayliss has to deal with an unsolved child-murder that haunts him throughout the series, the trauma of being sexually molested by his uncle, and a gunshot wound that changes his entire outlook on life.
- Nearly every detective on Giardello's shift fits this trope to varying degrees: Munch and his ex-wives, Gee's estrangement from his son, Kellerman being dogged by corruption allegations stemming from his time in Arson, the depression that drove Crosetti to suicide...and on and on.
- DCI Tanner in the series Second Sight: being ambitious, he attempts to conceal the fact that he's losing his vision from everyone but his detective partner.
- Subverted to some extent with Jonathan Creek, who is often seen as weird and out-of-touch by his sidekick, but usually deals with life a lot better than they do.
- Austin James in Probe is a genius in the Sherlock Holmes mold, and also socially awkward, callous, and, by self-admission, mildly schizophrenic.
- Brian 'Memory' Lane in New Tricks.
- Jimmy McNulty of The Wire is shown to be a supremely talented detective, but is also a foul-mouthed, alcoholic, arrogant, self-loathing womanizer who has a tendency to give a fuck when it ain't his turn to give a fuck. It's repeatedly shown that he has little-to-no life outside of detective work, and only shines as a person when he takes a leave of absence from detective work as a beat cop.
- Several in the Law & Order franchise:
- Law & Order: Lennie Briscoe had two failed marriages, a battle with alcoholism, and his daughter got involved with drugs and was later murdered by a drug dealer.
- Robert Goren in Law & Order: Criminal Intent has, over the years, had his quirks played up so much that, as of the current season, he recognizes that he's considered a nutjob by others in the department. Even he questions his sanity. And while Mike Logan isn't a brilliant detective, he's had to deal with a reputation as an out-of-control incident waiting to happen. Lampshaded twice: when he interrogates a fence while threatening him with a broken pool cue, and later when he gets a temporary partner who's even more of a hothead than he is. He even looks forward to being the diplomatic one for a change.
- Law & Order: Special Victims Unit: Elliot Stabler's anger issues. Olivia Benson's Child-Of-Rape Guilt issues. Munch's crazy.
- Bones. With her lack of social skills, Temperance Brennan may have a mild case of Asperger's syndrome. According to the show's creator Hart Hanson, Zack Addy "almost definitely has Asperger's syndrome." Brennan is also traumatized from her childhood with her parent's disappearance.
- Subverted in Foyle's War - even taking into account the World War II setting, DCS Foyle is usually one of the most well-adjusted people around at the time. His assistant, Sergeant Milner, is closer to the trope, as he has to deal with having had his leg shot off in the Battle of Norway, but even he's got his head screwed on tighter than some of the others making this list.
- Shawn Spencer from Psych gets in his own way more often than not because he comes across so buffoonish that almost no one takes him seriously. He's a lot more well-adjusted and relaxed about things than most of the other detectives here though.
- Shawn is, in fact, a brilliant detective pretending to be a crazy psychic because he believes the police won't believe the truth. Plus it allows him to act all goofy and solve crime without being a police officer.
- He committed prank that went bad and was convicted of car theft making it impossible for him to become a police officer if he wanted to. He enjoyed watching crimestoppers tapes and picking up clues that were very difficult to guess and sending them in on the police tipline. He did this so often, he was considered a suspect and had to claim to be a psychic to explain his knowledge to avoid prison time.
- Shawn's major "defect" is refusing to grow up. He is rebelling against his father, a former police officer who tried to get Shawn to join the force too and made Shawn pretty miserable as a child (though from what has been shown his father was just strict and meddling, not a particularly Abusive Parent). Shawn can't let his dad "win," and so avoids adult responsibility as much as possible, and only used his gifts for observation by making crimestoppers' calls until the psychic detective schtick gave him the chance to use his skills and be an embarrassment to his father at the same time. (The show is in some sense a delayed Coming of Age Story.)
- His rival/opposite number Head Detective Carlton Lassiter is socially stunted, coming down off of a difficult divorce, and extremely, unhealthily paranoid. He was also neglected as a child.
- Tony Hill of Wire in the Blood is very socially awkward and eccentric, prone to getting lost in his own tangents and neglecting practical matters. The fact that he's better at relating to the serial killers he profiles than to normal people has surely been lampshaded more than once.
- Raines: Detective Michael Raines would be haunted by the Victim of the Week until he solved their murder... except in his case, the people only he can see and talk to aren't ghosts; they're hallucinations.
- Find me a recurring Criminal Minds character who isn't dealing with PTSD flashbacks, traumatic childhood experiences, a family history of mental illness, a slight substance problem, intermittent explosive episodes, or chronic relationship trouble, and then be prepared to be proven wrong half a season later.
- Ever since JJ became a full-time profiler in season seven, she now fits the Defective Detective description (she was previously the media liasion). She had PTSD after Reid's kidnapping, she shot the guy that shot Garcia, her older sister committed suicide when she was eleven and the fact that almost every time the team has a case involving young blond women or small town women her demeanor changes. She either gets angry faster ("North Mammon") or just has that look on her face ("Birthright"). It's not as bad as any of the others' (Hotch, Reid, and Emily have the hardest time hiding it. Emily is blatantly obvious if you go back and watch "A Higher Power".), but it's still there.
- Actively subverted with DCI Tom Barnaby of Midsomer Murders, an easy-going, well-adjusted family man who is by far the most stable and sane character presented in the series, given that he lives in the deadliest rural county in England.
- Special Agent Alex Mahone of Prison Break, fully as smart as escape mastermind Scofield ... also a drug addict constantly teetering on the verge of a mental breakdown.
- Plus he has the body of a criminal he had previously hunted buried in his backyard. Something that gives him troubling flashbacks and allows The Company to blackmail him.
- Longstreet was a shortlived TV series about an insurance investigator who was blind.
- Charlie Eppes of NUMB3RS - a mathematical genius who uses his talents to help his FBI agent brother solve crimes, he has emotional difficulties to the point that he locks himself in the garage to work on unsolvable problems when he can't deal with life.
- Charlie is a university teacher who perceives criminal cases as interesting mathematical problems. So he is more Ditzy Genius than Defective Detective.
- In any case the garage thing seems to me to be little more then a mild eccentricity.
- Fitz in Cracker, an overweight alcoholic adulterer with a gambling addiction. For extra irony, he's a hypercompetent criminal psychologist who is capable of deducing anybody's issues in a heartbeat... including his own. He's just powerless to do anything about it.
- He does try,when it becomes obvious that his marriage and his relationship with his children is at stake. However, he finds he likes the way he is too much.
- Blind Justice. Jim Dunbar is a blind NYPD detective who was allowed to carry a gun.
- The American version of Touching Evil starred a police officer who'd lost most of his impulse control after a gunshot-induced brain injury.
- Ned in Pushing Daisies has the ability to raise the dead, making him the best murder investigator on the planet, and while not as obviously dysfunctional as someone like Monk, has layer upon layer of personal trauma that manifests as issues with intimacy, a paucity of real passions aside from his love of baking and his rewarding but frustrating relationship with his girlfriend, hyper-cautiousness and a general malaise. No wonder Ned has intimacy issues: if he even touches Chuck, she'll die, because he's already brought her back from the dead.
- CSI: Crime Scene Investigation, let me count the ways:
- Grissom is socially awkward and gets in trouble because he doesn't play the politics game. Early in the series, he had a near-brush with hereditary hearing loss that would've ended his career.
- Sara's laundry list of issues only start with having witnessed her mother kill her abusive father when she was young and worry from then on whether murder is a genetic trait.
- Catherine divorced her husband and work keeps her from spending enough time with her daughter, and oh, her father may be connected to the mob but no one can prove he's done anything. Then he got shot and died in her arms.
- Warrick started the series with a gambling addiction and a rookie dies on his watch because he left the scene to place a bet, near the end of his tenure on the show he starts abusing prescription drugs.
- Brass has an estranged daughter and left his old job in New Jersey because he couldn't be bought.
- Nick was abused by his babysitter when he was nine and has an issue with closed spaces after the "Grave Danger" episodes.
- Greg was traumatized after the explosion in the lab and later the entire "Fannysmacking" story-line.
- Julie Finn got fired back in Seattle for breaking the rules during a case. Of course, D.B. was that boss and she's working or him again...
- Morgan Brody dealt for years with her father, Conrad Ecklie,not doing anything to stop her mom from taking her and leaving when she was 14. Though they've gotten closer after she moved to Vegas and he got shot.
- The only one who mostly averts it is DB, at least in his background. During the series,though, he had his granddaughter kidnapped and his son suspected of murder for a time. Plus having to deal with the same son getting mixed up with the actual killer.
- CSI: Miami: Horatio Caine's mother and wife were murdered. Abused by his father.
- Mac Taylor of CSI NY lost his wife to 9/11. Framed for murder by a killer who committed suicide in custody. Shot and left for dead but survived.
- Lindsay Messer was the sole survivor of a massacre that killed her friends when she was a teenager. Had to shoot a deranged killer to protect herself, Danny and their infant daughter.
- Stella: Orphan and foster child. Nearly killed by abusive boyfriend.
- Jo Danville: Kicked out of the FBI by a vengeful senator after she turned in a Dirty Cop. Then the rapist in the case came back and nearly killed her.
- Danny Messer: Shot in the back and left temporarily paralyzed. His brother was beaten by a vengeful mob guy and may or may not be dead or severely damaged. Had his and Lindsay's home invaded by a deranged serial killer who held his daughter hostage and who Lindsay had to shoot to stop.
- Sheldon Hawkes: Framed for murder by the same guy who targted Danny and Lindsay,caught in a prison riot by the same killer and forced to switch clothes so the guy could escape, swindled out of his life savings.
- Adam: Abusive father.
- Waking the Dead: Detective Superintendent Peter Boyd, who believes that every problem can be solved by just shouting loudly enough. Violence prone, estranged from his son, and occasionally everyone else. Story arc in which he undergoes anger management therapy has somewhat predictable results.
- The Unusuals (as its name implies) features a whole bunch of quirky detectives, but the two who deserve special mention are Banks and Delahoy, who are partners:
- Banks, whose father, grandfather, and uncle all died at the age of 42, has himself just turned 42. He wears a bulletproof vest everywhere he goes (including to bed) and has basically idiot-proofed his entire apartment. He sometimes has panic attacks when he thinks he's going into a dangerous situation.
- Delahoy, who has been diagnosed with a potentially-fatal brain tumor, is a Death Seeker who suffers from visual and auditory hallucinations. Sometimes, he receives messages from fortune cookies that help him crack his latest case.
- The Inspector Lynley Mysteries: Oh my God. Lynley and Havers, both of them. One is a workaholic with a personal life worthy of a soap opera; the other is a Broken Bird who has raised antisociality and self-protection via jerkassery to an art form. Somehow, they become incredibly close friends anyway, which spawns an absolutely glorious amount of Character Development for both of them. And it is beautiful.
- Columbo either has shades of this trope, or pretends he does, so well that the audience never sees him slip. Certainly the suspects believe he's one.
- Michael Jericho of "Jericho of Scotland Yard" embodies this trope: His father was a dirty cop who was shot in front of him, and Jericho spends his entire career simultaneously trying to show his dead father up and make his dead father proud of him. He has no life outside his work, the only girl he ever loved married someone else while he and his partner Clive Harvey were off fighting in WWII, and his call-girl sometime-girlfriend winds up being basically kidnapped by the man who brought down Jericho's father. This leads him to be driven, harsh, and in so much pain it's difficult to watch at times.
- Gregory House from House is a narcissist, drug addict, and in great pain. Treating run-of-the-mill illness is beneath him. His only escape is diagnosing tough cases that have stumped other doctors, much in the same way that the Great Detective solves cases that have stumped the police.
- Detective Kate Beckett on Castle plays with the trope; she's clearly got issues surrounding the murder of her mother, but has apparently managed to more or less put it behind her at the beginning of the series ... until Castle unwittingly digs it all up again, leading to her eventually falling back 'down the rabbit hole' into her obsession with solving it over the course of the series. Season 4 further piles on by giving her psychological trauma following being shot in the chest in the Season 3 finale, leading to a complete PTSD breakdown in one episode. This aside this, even in the early episodes it's pretty clear that her mother's murder has left her more or less a cynical workaholic with little capacity to enjoy life outside of her job until Castle shows up.
- Will Graham in Hannibal is odd and unsocial and is hinted to have an Ambiguous Disorder. To top it off, he has the gift of "pure empathy" which allows him to get into the minds of the criminals he hunts and causes him to experience nightmares and crippling anxiety. Not to mention the encephalitis (which causes hallucinations, disassociative episodes, and severe headaches) and his psychiatrist not only kept this from him but is Hannibal Lecter.
- Benton Fraser on Due South: Lost his mother to a killer at age 6. Lost his father to another killer as an adult. His father (now a ghost) takes an intrusive interesting in spending time with him post-mortem. Framed for murder by vengeful ex girlfriend (who he had previously put in prison after they fell in love with each other).
- Ray K: Caught in a bank robbery that scared him so badly he wet his pants in front of his future (now ex) wife. Had his whole life uprooted so he could pretend to be Ray V while the latter went undercover, leaving him to deal with the fallout from Ray V's previous actions without knowing anything about them.
But he must have had Ray V's files, which he could read to find out about him and his cases. Ray V may not have put everything in the file, however.
I don't think he's as defective as Fraser or Ray V. The fandom just likes to make him into a victim.
- Ray V: Abusive, alcoholic dad whom he continued to have issues with even after the guy died.(another case of arguing with the ghost). Had his whole life uprooted to go undercover with The Mafia, only to have it happen again and have to deal with having been replaced by Ray K in the meantime when he returns to the force.
- Suikoden V's Oboro apparently has a Guilt Complex the size of a small planet regarding all the underhanded crap he had a hand in as Nether Gate's intelligence director, and it's heavily implied one of the reasons he hasn't chosen Redemption Equals Death is his desire to help those who've been scarred (mentally and physically) by his from his former organization. It's also more openly made aware that Fuyo, Sagiri, and Shigure double as his Morality Chain, and a living reminder of his guilt in the case of the latter two.
- Max Payne. Yes. Yes that's what the title character has.
- Schizo-Phrenzy, a platform game, has the lead private inspector chase after a masked baby... while avoiding monsters that randomly appear.
- The protagonist of 1997 Blade Runner video game, Ray McCoy, often seems a little bit dim and sometimes overly impressionable.
- The game "Defective" from the IGN Pirate Kart is about this trope. The player takes the role of a detective shooting people, and then has to navigate through pools of imagined blood.
- As of Tekken 4, detective Lei Wulong's girlfriend broke up with him because he'd rather solve cases rather than spend time with her. Considering he's not found another girl even until Tekken 6, he likely is still a huge workaholic. (Note that every time Lei enters a Tekken tournament, it's always because of a case he's on at that time.)
- Erika Furudo, the entitled detective in Episode 5 and 6 of Umineko: When They Cry, is first introduced as a Purity Sue but quickly turns out to be an arrogant, unempathic Attention Whore who is excited by the murders occuring, and treated even her boyfriend cheating on her as a criminal case. She describes herself as an "intellectual rapist". With a chopstick fetish. Yeah.