If you want a Muff style fuzz that works great for this genre and is really flexible, try the Wren & Cuff Pickle Pie B. It's one of the few modded Muffs I've played on which both the gain and tone knob are useful all the way around the sweep and it has a built in blend, which quite honestly I don't even think is necessary for a good tone. It doesn't have a separate mid knob, but it's not extremely mid scooped and I've never needed one.
Here's a clip I made of one with a P bass (tuned to B) into a GK MB800 into a Faital loaded Dually 2x15.
[Invalid or Expired Link Removed]
If you want something more on the thick overdrive/distortion side, I highly recommend a Joyo Ultimate Drive. They're cheap, easy to get and sound great for really heavy, dark tones.
Here's a clip of that, with the same setup, except into a ported Eminence Basslite loaded 1x10.
[Invalid or Expired Link Removed]
Here's a clip with my current go to BEAD bass (Carvin PB4) into the same rig, with a variety of pedals, including the two already mentioned and a couple boutique distortion and fuzz boxes.
[Invalid or Expired Link Removed]
There are a lot of great boutique fuzz, overdrive and distortion pedals that sound great for this style, depending on what kind of tone you're going for, the overall band mix and your budget. These are just two easy to find pedals I've had a lot of experience with. I don't currently own the Pickle Pie B anymore, but I would buy it again in a heartbeat. My bass tone on the Warp Rig demo that's linked below is about half that pedal. I was using a dual rig setup with that on one and a Dunwich Wizard Fuzz on the other. I currently use a custom Dunwich Cthulhu Fuzz Deluxe when I want a good fuzz for downtuned stoner/doom type tones, but like I said there's a lot of good stuff out there and definitely more than one way to get a good tone for these styles.
Also, I don't drink or smoke anything either, you can still like any kind of music despite whatever people want to call it. Lots of "stoner rock" and "stoner metal" style bands that don't really have anything to do with being a stoner.
EDIT:
Not as high quality of a recording, but in case you're curious about the tones with a loud tube amp instead of solid state, here's a clip that has the Joyo and the Dunwich CFD, along with a Boss ODB-3 (good reference point for known tone, I think) into my custom 300W tube head and an Ampeg 810e.