Well for me it comes down to the samples. I think with Superior Drums you only get the Avatar kit, which is an amazing sounding natural kit. It is pretty easy to use. I have only heard it used and played with it at other studios, I don't own it. EZDrummer I used a lot too. The Pop Kit sounds the best, but for Metal the Drumkit from hell beats were killer, I only liked the cymbal samples though.
I prefer Steven Slate Platinum with the virtual instrument which is Kontakt based. They are processed and sit in a mix really well. With some tweaking to flavor they are really really awesome. They are especially useful when I need something big and great sounding and fast.
But there have been times when I wanted a very natural kit, and I couldn't get it quickly with Slate. Ended up using a V-Drum kit in that case. Short time crunch. I need to spend more time with the SSD. Maybe the Steely Dan kit.
Battery I like when I want drums for effect! But I have heard guys do some cool stuff with that as well. I got with Komplete, so I haven't had a lot of time to spend with it.
For "programming" drums, I heavily depend on EZ Player Pro and beats from EZDrummer DFKH and Pop. I also bought a couple MIDI packs and a Groove Monkee pack. Then I'll direct edit or hack out drums on a keyboard. I have a V-drum kit for real drummers too.
For metal, you really can't go wrong with the Slate stuff. Maybe grab a few MIDI packs for canned beats. I even like Slate over the Metal Foundry stuff. Just put them on, leave them alone and you will have a great sound. Tweak the other instruments to make the drums sit, which is usually minimal with decent sources. But you can tweak them to taste to really make them fit the mix and vibe really well too.