My take on all of this, which will vary based on your preferences, goes like this:
Studio:
If you want a clean bass tone, you don't necessarily need any dirt, but I do find a bit of dirt can help your tone sit in the mix better. A little goes a long way. Adding a little seems to help my tone "spread out" and "glue" everything together a bit better. If it's sparkly clean I actually think that it gets too dynamic and can cut through the mix too well. Likewise, an overly distorted tone can get so compressed that it will cut through the mix too well. It's all about finding the right balance between clean/distorted and dynamic/compressed. This will vary from user to user as well as within different genres. I'll typically put a Radial JDI or J48 in front of everything, then mic up an amp/cab that's either tube-based and being driven hard enough to break up ever so slightly, or solid state with something to emulate tube breakup. I'll make sure everything is properly aligned in post and the results are usually great for the overall mix and achieve something that couldn't happen with just the clean signal or just the dirty signal. Again, when I say "dirty" I'm not talking about much more than some slight breakup.
Live:
This is always a guessing game. I typically give the soundman a DI just after my effects, but before my amp, and a mic on my cab. If he wants some dirt, I can supply that, but typically sound guys want the bass clean and compressed. I can supply that too.
Studio:
If you want a clean bass tone, you don't necessarily need any dirt, but I do find a bit of dirt can help your tone sit in the mix better. A little goes a long way. Adding a little seems to help my tone "spread out" and "glue" everything together a bit better. If it's sparkly clean I actually think that it gets too dynamic and can cut through the mix too well. Likewise, an overly distorted tone can get so compressed that it will cut through the mix too well. It's all about finding the right balance between clean/distorted and dynamic/compressed. This will vary from user to user as well as within different genres. I'll typically put a Radial JDI or J48 in front of everything, then mic up an amp/cab that's either tube-based and being driven hard enough to break up ever so slightly, or solid state with something to emulate tube breakup. I'll make sure everything is properly aligned in post and the results are usually great for the overall mix and achieve something that couldn't happen with just the clean signal or just the dirty signal. Again, when I say "dirty" I'm not talking about much more than some slight breakup.
Live:
This is always a guessing game. I typically give the soundman a DI just after my effects, but before my amp, and a mic on my cab. If he wants some dirt, I can supply that, but typically sound guys want the bass clean and compressed. I can supply that too.