I've been using EZ Drummer in Cubase SX3 for a few years. I like that it is very flexible and easy to edit/mix. Don't like the snare, change it with a click of a button. Need more room mics, just adjust the fader.

I record the midi drum parts using a set of Roland V Drums, then assign EZD to the midi track in Cubase. I can adjust timing, add or delete crashes or just play as recorded. And again, EZD is very flexible. You can use it as a stereo pair or assign it to multi-track. And they have alot of add-on kits and percussion.

Here are a couple of tracks I produced using EZD.

GTR

Sound Sketch

Test Drive

Good luck with your search!

EDIT: I should note, I'm more of a guitar player than drummer...I drum enough to get by on my demos.

Peace,
Mark