Yip, knew I missed someone obvious out, Les Claypool is amazing. So is Robert Trujillo (suicidal tendencies*, ozzy osbourne's live bassist etc) but I've heard him play some very low key stuff on the Jerry Cantrall tribute album.
* who would kick ass but for that dreadful singer mike muir.
If I couldn't laugh at myself how could I laugh at someone less ridiculous?