I own...
EZDrummer
Superior Drummer
Addictive Drums
SSD 4.0 Platinum
Expansions for EZDrummer/Superior... Metal Foundry, Drumkit From Hell, Metal Heads, Metal Machine, Rock Solid.
If you want my suggestions... All are really good depending on what kind of music you're recording. I have a love hate relationship with all of them. Out of all of them though, I've probably used Addictive drums the most for when I'm recording/mixing for clients, and it's probably the most versatile, but it's my least favorite sounding for the type of music I write/record myself. I would never use the EZDrummer or Superior Drummer stock sets. They've become overused and immediately recognizable, although I've heard some amazing mixes incorporating the Avatar samples, although heavily processed combined with additional samples. Great sounding room mics on those samples!