The Tone Zone and Breed are the most versatile and (arguably) toneful on your list. They both have alnico 5 magnets. The Tone Zone has deep lows and low midrange, presence in the treble frequencies, and the feel is not loose and not real tight. The Breed has a little bit less lows and low mids, more upper mids, brighter overall, and it feels slightly looser than the Tone Zone. Both pickups can get a little muddy with high gain because of their massive midrange, so you have to scoop the mids on your amp a little bit or use an EQ to get more clarity for heavy chording.
The Super Distortion is the 2nd most versatile, is hotter than both the Tone Zone and Breed, but has a similar thickness in the mids and lows. It's a bit darker than the Tone Zone. In my experience, it doesn't necessarily get muddy, but it can lack a bit of definition for heavy distortion because it's a bit dark and has a thick midrange. That's why I suggested the D-Sonic because it's warm like the Super Distortion, but more clarity, presence, and not so much output.
The D Activator probably has the coolest overall metal sound because it emulates active pickups. I have never used a passive pickup that could get that kind of crunch and harmonics without sounding too over-the-top. To me, the Duncan Distortion is a bit over-the-top and the D Activator is just short of sounding like that in my opinion. The Duncan Distortion is slightly brighter than the D Activator, but the D Activator seems to have a similar presence. The D Activator is more articulate than the Duncan Distortion and has a more characteristic sound. The Duncan Distortion has slightly more low end, but they both seem to have a thick midrange. Neither of them sound scooped at all. You will get more dynamics with the D Activator which seems to clean up better with the volume control and softer picking, but I think the Activator might be a bit hotter than the Duncan Distortion.
I can't tell you a whole lot about the Dominion because I have only played it once. It's similar in a way to the D Activator because it has a lot of clarity even though it has noticeably more midrange than the D Activator. I think maybe in a slight way the Dominion is more organic than the D Activator. It's still a thrash pickup though.
It sounds like you need a D Activator. Why don't you just go buy one? Dimarzio has a 14 day exchange policy so if you don't like it then they'll let you choose another pickup instead.