Atlanta didn’t do so well in Gone With The Wind.
The OP excluded songs, but NYC is not in good shape (except Queens, apparently) at the end of Billy Joel’s* Miami 2017*.
The OP also excluded historical events. 
Doh! At least it was in a work of fiction.
Hollywood gets destroyed by a sharknado.