Some of my favorite libraries include:
-GetGood Drums - Both 'Modern and Massive' and the original. Great sounding drums for rock. Very organic and have great room sound. The cymbals sound amazing as well.
-That Sound - Tons of incredible libraries focused on organic sounds. I have 1985, Mammouth, Nirz and Jeff, and Neon libraries. Excellent stuff and not too expensive.
-NI's Abbey Road 60s Drummer
-SSD5 - Can't go wrong.
-Drumforge - Great for metal music, though there are unprocessed samples included that can work for any genre.
-Double Cream Drums - Very dry, 70s funk, disco kit. I just used it on a production today, very cool sounding and dead.
-Superior Drummer 3 - Looks pretty awesome, though I haven't tried it.
Some of these load into Kontakt or Battery, so you may need that before you're able to use them. I know for a fact SD3 and Drumforge are standalone, but I have NI Komplete. I used to write MIDI into Pro Tools, but I found that tedious so I found a used
electronic drum kit and now I just play all the parts live and then quantize them to taste. I know a lot of home recording studios are going this route, especially in metal.