I think this is key. I had a comp years and years ago, but moved it on because it didn’t do anything I particularly liked. It wasn’t until I applied particular settings to a recording (outlined in one of my earlier posts) that I heard something really useful and wanted to replicate that in my live sound, which I was fortunate enough to manage.
Oh, I feel that pain. I did a recording of two tracks with a Ric 4003s and in the rough mix it sounded great, gnarly and definitely a Ric. However, when the final mix was handed down, it was just a generic bass sound, all the character had been removed. This wasn’t by compression, but by EQ, all that nice gnarly midrange had been scooped out. I was not happy and it still stings today. Ironically, the producer/engineer is a bass player, go figure.