Some of us like the grainy texture overdrive gives the bottom end of a rock mix.
I'll give you an example(of which you might totally hate):
Dub Trio - 03 Bay vs. Leonard - YouTube
See how the bass kinda sounds like the truck in my avatar on the "rocky" parts?
That's the way to use distortion on bass. Similar to Geddy or Squire, cuts through but has lots of growl and a heavy sound like a diesel engine under load.