I think of such bass players all the time. The first three bassists for Jethro Tull, for example. I can't even remember their names.

Graham Gouldman of 10cc comes to mind. His stuff is incredibly melodic but not a rip of McCartney.

Peter Cetera during the greatest days of Chicago

so many more

Jeff Lynne as a bassist--pure genius.