As Designated Driver in the thread, let me post a non-alcoholic one "All I wanted was a Pepsi, and she wouldn't give it to me."
Drinkin' Too Much singer Sam Hunt is arrested for a DUI in Nashville after 'crossing a center divide and having two empty beer cans in his car'
How about a whole album about booze? See Basehead's Play With Toys released in 1992. One of my favorites of all time. This Washington Post article about the band from 1992 explains it better than I could. Excerpt below: Spoiler