My uncle was a detective for 25 years. He sees a therapist because it seriously messed with him. It would take a psychopath to see the things detectives and not be damaged.
Sometimes stereotypes exist for a reason. I would be terrified to meet a detective not troubled by his or her work.