I didn't use a compressor for years and years but when I was making recordings during lockdown, a friend of mine who runs a sound reinforcement company and also writes and records to a very high level, suggested some particular compression settings to make the bass sit in the mix better, after I sent him the demos to listen to. I applied these settings and was suitably impressed. This got me thinking that if that worked for recordings, then it must work for live work, especially given that pro FOH engineers use it. After listening to many YT demos and reading a fair bit, I settled on the MXR M87. It was within my budget and I liked what it did. Like a recording, I have at the end of my signal chain, pre amplifier to mimic that effect that made my recorded bass sit better in the mix, in addition, any inconstancies in level that come from my FX are evened out into the bargain (I had them set up by ear to be the same as the dry signal, but the VU on the M87 showed that they weren't the same at all). Also takes care of any 'hot spots' on your fretboard. My compressor is on all the time.
A word of warning. Compressors have been a source of, let's be polite, heated discussion on BC in the past. Hopefully, this thread won't descend into one of those.