They Might Be Giants (1971)

Every hero has a weakness, and Sherlock Holmes' weakness was Moriarty. Sherlock Holmes and Dr. Watson solve mysteries and search for Moriarty in 1970s New York City. The fact that Sherlock Holmes is a psychotic paranoid and Dr. Watson is a female psychiatrist fascinated by his case is almost beside the point.