I think that to judge a song solely on its (perceived) lyrical content is don blinders, and willfully miss the point. A poem is a poem, and a song is a song. I think "McArthur Park" is brilliant. When read, as the poem it is clearly NOT, I'm sure it sounds quite daft. But, when sung - with feeling - across its magnificent musical backdrop, it becomes a heartfelt expression of so many human emotions; a journey we can all share.
Those "worst of" lists tend to put me off, anyhow. I get the sense that most are compiled by failed and bitter musicians or songwriters. Screw 'em! Mean people suck.