Since it’s not particularly about bassists I guess it’s another topic than: Favorite Bassist? but it is close enough that there will be a lot of duplicates. Anyway… regarding your question I give the same answer I gave in the other thread:
My favorite musician and personal hero is Tim Minchin!
But he is a pianist.
As far as bassists in bands go I don’t have a favorite/hero.
I really like Charles Berthoud and admire him for his clean technique while being able to play good sounding lines. It’s both - extremely technical and sounds good. The second part is something some very technical bassists lack.