We just went silent stage at my home congregation. The problem for years was that the grand piano we had in the church just overwhelmed evereything, and we didn't really have a setup for silent stage. Our praise services outgrew the main sanctuary, and we had to move to our multipurpose gym.
I have to say that after a really steep learning curve, we seem to be doing OK with individual mixers (in our case, Hearback), and silent stage. PODs for the electrics, DI for the acoustic, Sansamp rack unit for the bass, and a keyboard in lieu of the grand. We've had electronic drums for a while. Singers still have a couple of floor wedges, but otherwise, it is a pretty silent stage.
Have to say we have killer speakers, with a huge subwoofer, that allows great lower bass and drum frequencies through, so the congregation seems to like the setup. I'm getting custom molded IEM, with quad drivers, and that should make my job on bass or guitar easier.
It doesn't have to be all bad, but the transition is indeed painful.