This. Distortion, Fuzz & Overdrive on bass can be a bit too much, and IMO, tends to get lost, even with all the new & improved sound sculpting options available today.
Yes, the type of music being played, and the band playing it is important. If a driven sound is appropriate for the type of music, then an ear should be stuck out for how the bass will sit in the mix with the other instruments, especially if there are more than guitar, bass & drums involved.