If you like cheery songs about decidedly uncheery things, you might love They Might Be Giants. (Am I plugging them enough?
They deserve it.)
John described "Revolution 9" as the sound of a revolution taking place, and that's what it is. I love this sort of stuff, sonically but non-musically illustrating a scenario. I've done stuff like that myself before realizing that "Revolution 9" was the first example of it. See "Life In A Fish Tank", "Three Internet Geeks Arguing While Driving In The Rain", and "The Wind Tunnel" in the Audio section of my website (in my signature) for mine.
Another favorite of mine is "Wild Honey Pie". I didn't appreciate this one for a long time, until I read a comment Paul made about its creation, that made it all snap into place for me, and now it's one of my favorites. Obviously it's not about
anything, so what is it? Paul mentioned something to the effect that he recorded it all himself, adding layers upon layers of guitars and vocals and other sounds, building it up sculpturally. That's what did it. When I listen to the song as a musical sculpture, it becomes much more enjoyable for me. I realized that everything sounded really unusual, sort of sproingy. It's basically an experiment in creating an experience of sonic texture, sort of like feeling various rough, smooth, cold, warm, etc. surfaces with your fingers. I love this crazy experimental stuff, so it's now one of my favorites.