The screen 's most-filmed detective came to Manhattan in '' Sherlock Holmes in New York , '' a 1976 pastiche that included Roger Moore as Holmes , Patrick Macnee as Watson , John Huston as the evil Moriarty and Charlotte Rampling as Irene Adler .