"Icky Thump" by the White Stripes; you don't have to listen to this one long before you get why it's on this list, and almost at top.
The Slumber Party's song "Drunk" is from their third record,3, which you can purchase here as a download for just $7. Sorry, I couldn't find it for free anywhere.
Not Detroit, but the Meatmen cover it, with special permission from Gang Green
Ray Taylor describes Hamtramck "where the lights are bright" and walking into the "Hamtramck Bar"
And, it ain't "Beer Barrel Polka" but ... it's polka.
Protomartyrs' song "Jumb'os" has to be on here — that's a bar so rad, it's even a favorite for people who don't drink. And i don't care if the bar named themselves for the song, and not the other way around which seems improbable given the space-time continuum.
And of course there is Bantam Rooster's "Hey Bartendress"
And we end our list with aK9 Sniffies' track "I'm Drunk," just because.