The software drums all have their pros and cons and it really depends on what YOU need. I have BFD, Superior, EZDrummer and Addictive Drums and I do like Addictive drums. I end up having favorite kits from each one
Addictive Drums comes with a set of presets covering a pretty broad range of sounds. It's lightweight in size and CPU. I saw it on sale at Guitar Center a few weeks ago too, so check around. They do have a demo so I'd recommend checking it out.
If you're looking for BEST sound and ULTIMATE tweakability I'd say BFD followed closely by Superior. Addictive Drums may be enough for you (again, check the demo) and it's lighter on the wallet and computer, and like all of them, fun to play.