Sometimes a snappy title can be the difference between a hit song and a classic. "Stairway to Heaven" might not have been quite as memorable if it had been titled "Ed's Garage," for example.
Often it seems like musicians just pulled a cool combination of words out of a hat, and that's fine -- artists are allowed to be abstract and weird. It just kind of blows when you find out that the cool combination of words actually does mean something, and it is something really simple ... or even just kind of stupid.
4"Hair of the Dog" by Nazareth
If you don't think you've ever heard this song, it's only because you've always thought it was called, "Now you're messin' with a SON OF A BITCH!!!"
And yes, "Son of a Bitch" was Nazareth's intended title for both the song and the album. The record company said (fuck) no, so they just made a bad pun on their title. "Hair (Heir) of the Dog." Get it?