The Seven-Per-Cent Solution (1976)

To treat his friend's cocaine induced delusions, Watson lures Sherlock Holmes to Sigmund Freud.