This movie has a great sound track near the end when the detective finds out that the murderer is the same person that developes peoples home movies.

Maybe Manhunter, which featured the first appearance of Hannibal Lecter (albeit not played by Anthony Hopkins)? The climactic scene is set to the grandiosity of Iron Butterfly's over-the-top epic "Inna Gadda Davida".