There is a spectrum of "worship" music often dependent on the setting, from huge protestant megachurches, to a medium-sized Catholic church that I attend, to small independent churches. I don't know about synagogues or mosques.
I think it's hard to be a good worship drummer because there often are so many constraints. Tempos tend to be slow, you're often stuck way in the back in a plexiglass enclosure, you do a lot of cymbal rolls or whooshes with soft mallets. A really talented music director can improve the experience immensely.
Worship drummers have been a boon to companies in the US like Sweetwater. Thousands and thousands of kits are in churches. Whenever I'm in an unfamiliar church (pre-Covid, that is), I walk up front afterwards and have a look at the kit. The gear is often pretty sweet! As for "worship pack" cymbals, maybe it's an easier sell for the music director to make to the church's financial officer. I've heard a lot of offerings taken for specific purposes (high school mission trips, new roof, etc.) but never for a new set of cymbals!
I've only been an observer. The closest I ever came was playing drums for "Joseph and the Amazing Technicolor Dream Coat" as a teenager at a local church, which was loads of fun, actually, because the music director was a real character.