Movies like loose cannons

Loose Cannons is a 1990 American action comedy film written by Richard Matheson, Richard Christian Matheson and Bob Clark, who also directed the film. The film stars Gene Hackman as a hard-nosed cop who is teamed up with a detective with multiple-personality disorder, played by Dan Aykroyd, to uncover a long-lost Nazi sex tape, featuring Adolf Hitler, which would jeopardize the political future of the German chancellor-elect. The theme song features vocals by Katey Sagal and Aykroyd.