Dude, saying Roger Waters is your favorite bass player is kinda like saying Babe Ruth is your favorite baseball pitcher.
Yes, Roger Waters is great and Roger Waters is a bass player. But his bass playing is not why he's great. I'd put him in the top 10 best lyricists and he was a fantastic songwriter (although I'd describe him as an "ideas guy" more than a "songwriter"). David Gilmour said that he recorded half the basslines on the PF albums.
I'd cast my vote for Andy Rourke of The Smiths. There are flashier and more technical bass players. But Rourke's playing would enhance the song and the overall music very tastefully. His basslines have been described as "a song within a song" which is a pretty accurate description, IMO.
Examples:
This Charming Man
Heaven Knows I'm Miserable Now