On a side note, why does Collective Soul have the word SOUL in their band name? The Partridge Family has more soul then these guys.
As far as good tone bad songs, not a whole lot come to mind right now. Maybe because I rarely listen to truly bad songs for any period of time. I can think of some bass players who have never blown me away with their bass lines per say. In other words I've never been "wow, I have to learn that line" who have great tone over some good songs. Adam Clayton and Dug Pinnock (Kings X) come to mind. Dug, is a good player, the band has great songs, he has great lines for the songs, but their not really my style, but his tone is the definition of a modern power trio. I always felt Adam Clayton's tone killed in U2's songs (some excellent) but I never thought he was more then a mediocre bass player.