I've had the classic+, classic, single coils and p90s. Never tried the ddd though.
Babmusic is on the money with his assessment. They are good pickups, all of them I've tried sound good. It's just a matter of if they have what you are after. They aren't high output, I found them best suited for rock and hard rock with a boost or maybe classic metal. The ddd is highest output and probably better if more modern and higher gain tones are desired.