I think the king of really great tunes that fit in the "inappropriate category has got to be Vehicle by Ide's of March. Though the lyrics were not written with the intent that it seems to convey, it certainly doesn't pass the test of time. I'd be really surprised to hear it while shopping in the grocery store.
Great tune where you practically miss the opening two lines. It opens, Well hey, I'm the friendly stranger in a black sedan, won't you hop inside my car. and gets worse in the send line.
Art, it's not always appropriate. Just check out any art museum. It does however often reflect reality.