The Naked Gun: From the Files of Police Squad! (1988)
You've read the ad, now see the movie!
When the bumbling Lieutenant Frank Drebin investigates events following the shooting of his partner, he stumbles upon an attempt to assassinate Queen Elizabeth II.