I think it depends on the genre and your intended audience. Like the song context, the importance of the title varies from one genre to the next.

Personally, I like quirky, catchy titles. But, they don't seem to be in fashion at the moment. I think as songwriters, we're more concerned about the title than the listener is. There are exceptions, but they're exceptions for a reason. As the song's composer/lyricist, it's our baby and we want to dress it up real pretty with a sweet title. It's kind of like a baker/cake decorator...he/she spends a lot of time getting that fancy design on the icing just perfect ... but it doesn't make the cake taste any better. Unless the cake is for a specific event or function, I don't think most folks care too much about how pretty the icing is.

But, I could be wrong.

Al