Maybe it's because I grew up in one, but I like songs slamming such towns. As Big Black say in the following tune "never anything to do in this town/but stare at each other and wait til we die":
https://www.youtube.com/watch?v=EXV6EmSBULY
And then there's Johnny Cougar, the pre-fame John Mellencamp, who didn't exactly praise the virtues of a "Small Town":
https://www.youtube.com/watch?v=-8C5UdgNp8o
And then there's one from Elton John--"there's nothing to steal/so there's not a great deal of crime":
https://www.youtube.com/watch?v=eDGsCJJ9hxA
I know a number of other such songs. I'm curious to see what ones others can come up with.