Because I have no other option, I can't do studio drums. I use EZDrummer from Toontrack. Great production quality but you get what you get...a decent selection of beats.
However, I find that I can take those provided beats and 'adjust' to what I have in mind. Since I am not looking to program Neal Peart (Rush), I can do that. I have reasonably simple, if specific rhythmic needs.
For me, EZDrummer works very well. I have a number of the expansion packs to get different production values.
So, if you have a specific rhythmic need, a studio set up might be best. Keeping it simple, virtual instruments with good production is a great way to go.