I don't think this one has been mentioned yet--the awesome but short-lived show The Chicago Code had an amazing theme by Billy Corgan and beautifully shot opening credits.
Brisco County! We actually talked about this one on our TV-pilot-themed podcast, Wings. Brisco County was insanely entertaining, and man, did it deserve more than Fox gave it.