The Seven Percent Solution (1976)

Sherlock Holmes is tricked into seeing Freud (a very droll Alan Arkin) in this battle of the super brains, who then join forces to solve a mysterious abduction. Freud cures Holmes of his pesky heroin addiction, but isn't happy until he's uncovered the root of his problems, which, naturally, stems from a major childhood trauma.