the snare here is almst midi-like. the rest sounds alright, cymbals could use some volume though, they're being overpowered.
well, personally, I use Superior 2.0, and I love it to no end. Cheaper alternatives are EZ drummer and Addictive drums, as were already mentioned, which are also pretty good. EZ drummer is about 100 dollars last I checked, it's quite worth it from what I've heard of it. it also offers a ridiculous amount of expansions.
I don't know how it is with other software, but I use SD2.0 with a drum map in Sonar, for sequencing it's really easy that way. I'd also like to point out, should you consider SD2.0, that although it sounds good raw, it takes some skill/practice to get it to sound its best. it's almost like mixing a real set of drums (though one that's been recorded with a BADASS set of drums/cymbals, mics, room, drummer, engineers, etc). I have yet to learn more of how to handle it.