It all depends on what you’re looking for in a bass player.
Geddy Lee and Chris Squire are obviously very talented and technically proficient players. Nobody can take that away from them. But their music bores the shit out of me. Except for a few notable instances, the concept of subtlety seems to elude them. I’d rather listen to Dee Dee Ramone pound away on root notes for 10 Ramones albums then listen to 30 seconds of “YYZ” or Tales of Topographic Oceans. (Squire bores me a lot more than Lee does. Actually, Lee’s playing on Moving Pictures probably suits the songs more than on any other Rush album. IMO, anyway.)
While McCartney is obviously not as technically proficient as those two, he knows how to make a bass line fit a song. Look at the difference between the walking bass of the verses in “Penny Lane,” the thudding octaves of “Helter Skelter,” and the bluesy riffing in “I Want You (She’s So Heavy”. He understands the role of the bass in each and every song, and plays appropriately. That should be the role of any musician – to not over- or underplay the song. He is my personal sentimental favorite.
As long as we’re not limiting ourselves to the electric bass, Mingus obviously has to be in there.
Entwistle overplays on a lot of songs, too, but in that respect he was the perfect partner for Keith Moon. He really does play some terrific stuff, and takes what would often be rote or cliche material and does something surprising with it. (Think of what he did on a simple “rawk song” like “Baba O’Riley.”)
**James Jamerson," the Motown house bassist for many years. That man laid down the groove in a major way. If I could be anyone, it would be him.
I can’t believe, though, that nobody has mentioned the incredible, peerless Carol Kaye. As a session bassist and frequent member of Hal Blaine’s Wrecking Crew, she set the standard for pop/rock/soul bass playing. Look at some of these titles on which her work can be heard:
“I Was Made To Love Her,” Stevie Wonder (This song alone elevates her to Goddess status!)
“River Deep, Mountain High,” Tina Turner
“Bernadette,” the Four Tops
The entire Pet Sounds album, especially “Here Today”
Nearly every significant Supremes single
“Light My Fire,” the Doors
Tons of singles for the Monkees, Simon & Garfunkle, Ray Charles, Henry Mancini, and on and on and on.