Agreed about Manhunter.
Last of the Mohicans is okay, but it's too glossy. Count me as one who still thinks the book is better. The silent version by Maurice Tourneur is better looking and more atmospheric. I think the Mann version might be based more on the 1930s version with Randolph Scott, and I guess the Mann movie is better than that one, from what I remember.
I've never seen Miami Vice, and I've never seen an entire episode of the show, but onetime I was flipping through the channels and stumbled on an episode that had a gunfight scored with Pink Floyd's Dogs of War.