I usually play active P-style basses, but I have a couple of passives I really love. I also have a couple of MM style basses (active, of course).
I haven't tried 'em all (very far from it), but I've been doing lots of research this year, and here are my favorites:
Darkglass B7K: Tilts toward the modern end of the tone spectrum, but amazingly versatile
Darkglass Vintage Deluxe: as you'd surmise, tilts toward vintage tones, also versatile
VFE Triumvirate: three band overdrive, you can adjust OD on treble, midrange, and bass frequencies separately. Capable of crazy synth-style sounds, but I use it for dirty highs and clean lows+mids -- it gets tones similar enough to a stereo clean/dirty rig
Ashdown LoMenzo Hyperdrive: very cool and underrated pedal that allows you to overdrive a sweepable band of midrange frequencies (goes from low mid into the treble range, actually). It's capable of heavier OD, but I use the Mix control to dial in somewhat-subtle always-on midrange distortion that sits great in the mix
Empress Multidrive has three channels: Fuzz, Overdrive, and Distortion. Sure, you can select just one channel, but the cool feature is that you can blend two or three together however you like. Also, each channel can be run lowpass, highpass, or full range! I typically use heavy Distortion on my highs, and blend that with the Overdrive channel run clean or with very light OD -- as with the VFE, it simulates a stereo clean/dirty rig. Despite my TB username I don't use fuzz when I gig, but that channel is fun to play with at home
Honorable mention to my SansAmps: Bass Driver DI and VT Deluxe. I've been spending more time with the newer pedals listed above, but these classics aren't going anywhere.