There are lots of Sherlock Holmes-ish movies. One of the best is Jake Kasdan’s The Zero Effect (1998) starring Bill Pullman and

Original theatrical trailer for the 1998 film “Zero Effect.“ Starring Bill Pullman, Ben Stiller, Ryan O’Neal, Kim Dickens, Angela Featherstone, Hugh Ross, Matt O’Toole. Written & Directed by Jake Kasdan. From Warner Bros. Pictures.