Jamstix
I really really do not know why I did not fork out 99 bucks for this a long time ago. It really is an amazing product. The trick is to set the input trim and velocity curve so that the 'power' knob moves smoothly up and down with your playing dynamics. At that point choose a kit, style and virtual drummer, (each of whom has their own quirks and unique playing style), press play and - voila. Instant drums, which track your playing and vary from quiet stick and ride through to full on dynamics, fills etc as you play louder. It's extremely quick and easy to define song patterns by typing in things like 'VVCV' for verse and chorus, etc; this is a product designed by musicians for musicians, in my opinion.
The included kits are fairly decent and have the merit of loading almost instantly, but you can route the output to any drum plugin you prefer.
I don't know if it's possible to somehow have it follow tempo changes other than presumably adding them subsequently but I can live with that. What Jamstix does is take away the painful tedium of fiddling with loops, patterns, grids and trying to tap in drum parts either on the keyboard or via pads. I know lots of people can do this well; I'm not one of them. Highly recommended. (ps: tested with Reaper but I believe there are Sonar users)