I've got some familiarity with DiMarzio pickups, but I've never used Seymour Duncan, so I can't comment on them.

Your technique becomes important here. With a new-design, hot, touch-sensitive pickup like the Tone Zone, you can get very expressive sounds. Joe Satriani uses it. The Fred is another pickup like this, with a slightly different frequency emphasis. The 'catch' is, that because it is so touch-sensitive, you need to be very consistent and controlled in your playing, or the results become unpredictable, and you may find yourself fighting to control the gain-generated overtones.

Something a with less sensitivity to attack, like the older style Super Distortion, or maybe the PAFF Pro, might give you better definition of the notes, a less blurred sound. But then you lose a lot of the expressiveness available from the newer designs.

Me? I play mostly Blues/Classic Rock. I use Super Distortion for the bridge, and a Super Clean Hum Bucker (SCHB) at the neck.