Zero Effect is Jake Kasdan's contemporary take on Sir Arthur Conan Doyle's A Scandal in Bohemia. The magnificent Bill Pullman stars as S̶h̶e̶r̶l̶o̶c̶k̶ ̶H̶o̶l̶m̶e̶s̶ Daryl Zero and Ben Stiller (playing it straight!) is his Watson.
This is one of my favourites, I make sure to watch it at least once a year. It is severely underseen; more people need to check it out.