I learned a while ago not to generalize what's great and what sucks. What sounds awesome in one guitar may sound so-so or worse in the next one. I used to hate EMG's until I played a guitar where they sounded fat and meaty...none of the sterility that I had come to despise in my past experiences. I hated the Dimarzio Tone Zone until I played a guitar where it was the perfect fit...same with the Super 3.
Conversely the Anderson H2+ is my favorite pickup, but I've come to find that it doesn't work in everything.
Duncan, Dimarzio, EMG, Gibson, etc all make great pickups that will work well in the right application and not-so-well in others. Finding what works for a particular guitar is part of the process of dialing it in for your needs.