Properly using pedal compressors will yield good results the first or close to the first time if you had used compressors in the studio for recording. But since 99% of us are not tracking, mixing or mastering engineers, we probably do not know how to use compressors or we think we do. Before all these fancy pedal compressors, I used a DBX 160 rack unit and that thing was great and almost no brainer.
The other route is to get the Source Audio Atlas compressor. Why because the curated default bass mode 6 presets just work. What this does is that it gives a novice 6 compressor types and a familiarity of what they do. Then later on you can get a boutique 700 dollar compressor pedal and will not look like a fool using it because you got the education with the Source Audio. Yes the thing is digital but the latency is very low. The guys in this company used to work with Analog Devices that made the DSP chips and know how to extract the performance out of this chips. I honestly can't tell the difference and unless you zoom within 0 to 2 ms in a spectrum analyzer, there really is no practical latency that will affect the compressor performance,
And if you are a tweaker, you can definitely adjust the 6 default presets to your liking. One thing that OP is complaining about is the excessive clamping on the low B and that can be mitigated by using a Dual Band compressor. Google what it means and probably what you need. The other thing that they have is the look ahead feature in one of the presets.
And on the flipside, the old MXR one knob compressors and others before and after it can also work for some people and yield good results. Maybe it's just what the doctor ordered.
And as
@Killing Floor said, your probably need to own 10 - 20 more to find what works for you. That is why we have compressor mega thread that is going for more than a decade now. Dive into that thread and listen to the samples and join the discussion.
@scubaduba compressors reviews and sound samples are excellent.