Church settings, like most live venues these days, are going to E-drums. It's the same reason that most of us are here, and the big Marshall is collecting dust....
Roland uses synthesized sounds, and everyone else seems to be going the way of sampled IR's . They do sound very good in the mix. Roland makes really good, durable kits, they are probably the best e-drum kit you can get. I've had various over the years, and have only had to replace cables.
Currently, I am using a td-20 brain with all Roland cymbals, and a hybrid kit. The kit is an old Yamaha acoustic set with mesh heads and triggers. The hybrid kit goes a long way in making a drummer feel comfortable. You can tension the heads for a genuine response. The triggers don't work as well though. More machine gunning and the snare rim trigger has a mind of its own. But, every drummer that has sit at them adjusted quicker than with the electronic versions that worked better. And loved them! I think of it as the amp in the room syndrome.
I would recommend trying the hybrid style kit with the midi controlled software. It was really inexpensive to make myself. I picked the kit, with hardware off of Craigslist for $90 . Bought the mesh heads and triggers as a kit for another $150, and put them together in an afternoon.
If I was more serious, and was playing live/ recording, I would get the software as recommended above. But, for weekend practice and jam sessions, these are pretty slick!
