I just got my first true "active" bass. That being a NY Spector NS 5H2 with 2 EMGs. I have some vintage Musicmans and a couple Bart equipped customs, but I wouldn't consider those "active" basses. They have active preamps, but the pickups still have enough magnetism to run passive. In fact, they both have push/pull pots to turn the preamp on and off. I like the way a Bart preamp sound flat. I generally set and forget.
On to the EMG's. These pickups require juice to even work. Essentially electromagnets. My 5 string Spector has an OPB3 in it which is also a first for me.
I can see why folks think these pickups can sound "sterile." They also play WAY different with my effects and pedal boards which has been quite challenging. I also find that I need to tweek the frequency knobs a tad to get the sound I'm after.
The advantages/differences I found with the true active pickups, was the crazy detail and clarity in all the nuances and overtones. Especially during intricate slap/tap exercises. I do wish the tone knobs has detents for level as it's a pita to keep a knob in the right place and reset it all the time. It wold be good to have a consistent reference point.
I do kind of miss my Barts, but I will give this EMG thing it's full trial run. I can definitely see a use for it, especially in the studio.
When it comes to gear and music in general, I don't discriminate. If it sounds good, it is good and a good bass player will find a way to make everything sound it's best. Why limit yourself?