The first time a bass player really got my attention was when I heard Led Zepplin's "Lemon Song". John Paul Jones was to bass, what Jimmy Page was to guitar.
Geddy Lee is another bass groudbreaker. (I wish he would just shut his mouth, and stick to playing!)
Any trio is likely to have exceptional bass. With only three players, every note and beat counts, and there's nowhere to hide.