My Dingaling by Chuck Berry is stupid, infantile and other things I won't mention. I saw old Chuck recently and he had his daughter on stage and sang it with her. I found it even more horrible to witness that spectacle than hearing it had been. And Chuck has written some of the greatest songs in rock n roll. Go figure.
Paul McCartney has written some real crap as well as some of the greatest pop songs of all time. How about "Someone's Knockin at the Door"? "Live and Let Die"?
Sting "Doodoodooodoo Dadadada". Need I say more?
How about Lou Reed? I loved the Velvet Underground, but for some reason the one song everyone wants to hear by them is "Heroin", an excruciating, headache inducing series of aimless sections which increase in pace and volume and just when you're sure it's finally over, Mo Tucker starts banging the redundant drum intro to yet another segment.