Assuming that you are happy with your amp or sim raw sound there are a host of great fx for sculpting the tone.
My favs for bass are:
Waves Bass Rider (always first in my bass fx chain)
Waves CLA Bass
Waves JJP Bass
Izotope Neutron's bass presets (easy to tweak)
Waves BB Tubes (great for a fat round effect)
The ones I use are, of course, based (haha) on the tone I want for the feel of the specific tune's mix.
So whether it is an edgy bass, a gritty bass, a little crunch hair around the edges, or the big fat tone these will get you there. I also pay close attention to the emergence of any unwanted changes on the bass when mastering.
Caveat:
I'm an upright player (on occasion

) but for electric RT's I always render them direct and apply Logic Pro Amp sims prior to establishing an fx chain from the above.
FWIW I think that often a lot more than compression and or limiting is needed for the "right" sound. And another FWIW, the Bass Rider is exponentially better than any compression (other than the mildest of it). It adjusts the volume of all notes to your satisfaction just like riding the slides in the old days and it does not compress, i.e., squash the notes. That is a big difference in your sound. And yes most of the afore mentioned fx have a compression module but in most cases it can manipulated. And then there is tape sat, sculpting and other variables and the simple fact that some fx have a distinctive way of coloring the sound that is hard to define but often is helpful in a mix.
YMMV
Bud