As with most everything else in life, it's horses for courses. I've seen compressors being used as effects pedals, as a general sound enhancer, and as a compensation for poor technique (that would be me then).
They're versatile, but a compressor can only really do one of those things at a time.
Ultimately it's down to your ears. If you can't hear the impact then that compressor or that setting is (literally) doing nothing for you. Others may make comments, and clearly they're hearing a difference, but can you?
Pete just mentioned the Demeter Compulator. Some years ago that pedal was absolutely flavour of the month here on Basschat - lots of love for it, lots of praise. I spent two hours in Charlie Chandlers trying everything I could to hear that pedal's subtle, transparent effect.
You know what's coming, don't you? It was so subtle and so transparent that I couldn't hear a damned thing. I left the shop with an MXR Dynacomp.
These days I use The Warden pedal by Earthquaker Devices.
Would I recommend it? To me, yes I would. To you, dunno - we've never met.