I'm in agreement. What I find is that there are cliches in titles just as there are in fics (like "Waking Dream", for instance), and I would rather have a title that either lends some tangible clue as to what the story is about, or leaves me so intrigued I click on the link to find out what it IS about. Titles like "Waking Dream" do neither, being of themselves too abstract to allow the reader to connect strong images about the story, and also too vague to allow the reader to ascribe a certain moral or theme to the story. So that's a turn off.

Also, if a title looks like it's straining too much to attain an alliterive, consonant or assonant quality, I'll think it overdone.

Myself, I tend to make my title either single (though I hope interesting) words, or bring in some sort of prepositional element (ie. Of Something and Something). I also on occasion use lines of poetry in my titles.

Either way, I agree; titles are a key element in the production of a Really Good Story.