There's a huge range of bass sounds in metal from super clean to fuzzy, clanky nastiness.
My bass sound is quite mid heavy with a good amount of grit.
I take a little bit of grit from the amp but most of it comes from a Darkglass vintage microtubes with gain up high but blend in the middle and then a Two Notes Le Bass preamp for added valve grit.
The most important thing in a band situation is to forget about what your bass sounds like in isolation, that doesn't matter. It's all about the sound when played with the guitars and drums. A lot of bassists who hear Lemmy's bass isolated will say it sounds dreadful but listen to it in the mix and it's perfect