I used to use a mix of drum sounds from various midi sources that include an MU80, Roland Orchestra and Quartet, various Emu drum samples, Alesis QS6, my old staple Korg X3, and some sounds from Sonar's Session Drummer. Mix and match accordingly, and ALWAYS record dry when it comes to midi. I emulate an actual recording session when doing midi drums, i.e., separate tracks for snare, kick, toms, crashes, etc., and eq accordingly. I may insert compressors as needed then bus them to a stereo channel which also has another compressor. I also use parallel compression techniques as needed. The secret to a great drum track is to ALWAYS ride the 'faders' and not only on levels. I also ride send levels, reverb levels, returns... the works, and I make sure that the automation is drawn in for final, repeatable tweaks.
If I have BFD, SD2, or even Steven Slate, I'd probably be doing a Marvin right now.