I just love the sound of my bass with no effects at all. ( I haven't ever used them live but tried a couple in a shop and it wasn't that I didn't like the effect ( envelope filter ), I didn't like what they took out of my sound, whether on or off. But in reality I have no need for them.
I wonder if the desire to play clean through a clean bass rig is popular these days as most gigs I go to the bass player has one or more effects pedals in their board.
I don't have any axe to grind with anyone using effects, as where I've heard them being used they work bang on with the music.
Most of the time I play clean, with no effects. The only exception to that is if I'm either playing some Funk, then I'll use a little Phaser or Envelope Filter, or when I'm playing some of Mark King's 80's bass lines where I'll use a good amount of Chorus.
I have a TC Electronic rig and one of the things that I love the most about it is that there's nothing baked in to color the tone of my bass. So playing my basses clean through it is an absolute pleasure.

