Rush: Limelight (1981)

Neil Peart did not feel comfortable with fan adulation. So, he wrote "Limelight" to convey his unease. Lack of privacy, autographs, gossip columns, journalists, etc all invaded his space. He borrowed from Shakespeare as well as his own feelings for the song. "All the world's a stage" is Shakespeare "and we are merely players" is Peart.

http://www.youtube.com/watch?v=EKpn0esJ73w

Blue Oyster Cult: (Don't Fear) The Reaper (1976)

The song will never die...despite being about suicide! Well, at least that's what most people think. Apparently, it's really about everlasting love. Guess that title was taken. Anyway, it has become a classic rock staple.

http://www.youtube.com/watch?v=cMYSWiPm7E0

and who could forget the SNL spoof:

http://www.youtube.com/watch?v=fZOHY7Z5eaQ