Find it funny this thread. That it always turns into something ying yang, black or white "either you're with us or against us" thing.
I'll bet if we all were exposed - live - to a blind test of any the famous bassists that we laud, and have us guess whether they used compression or not, would leave the most of us stumped, when the answer came.
Being a guitarist too, I have eschewed compression more and more, and was an avid user of it long time ago. It has to do with that you just want to have Santana like sustain on the solos and let the tone hang in there. Now, these days, I don't have to rely on "hanging in there" but play with dynamics instead and not saturate the amp. On bass, I can't think of any time, LIVE, that I used a compression pedal. I tried to, the one I told you about before. Worked not in my favor. In studio, yes. Sometimes. Depends.
That said, I don't think there's anyone who's going to use compressors all of their life, and people who hasn't used it before, are going to start using it now and then. People are going FROM using them, as well as TOWARDS using them during their course of their career. And everything in between. The main thing I don't use them live, is that I want to be able to compete with the dynamics of a drummer. If he accents some hits, I want to be able to make that snap too, at equal levels, and then carry on carress the strings like a baby. The subtle compression inherent in the tube preamps or amps as such will do fine with me. So that one, in addition to - say active pickups like EMG who has built in limiting of some sorts, due to batteries (they put out 9v max), leaves me not wanting to add another compressor on top of already compressed sound.
So yes, in a way I use compression, but not a compressor. Get it?
As with all kinds of effects, it's an effect. A regular compressor pedal, on all of the time, can be as tiring to listen to for any length of time, as with any other effetct. Distortion, flanger, chorus, phasers, auto-wah/envelope, yeah you name it. Just like the listening fatigue present when listening to heavily mastered production techniques of today (look up the loudness wars).