Jean I think that there are similar lessons to be learned from both your church music and my cabaret/entertainment type of stuff. People go to clubs and bars to drink socialise and be ENTERTAINED. People go to church to worship and entertain God so sometimes they may have to perform music that is not to their own personal taste or liking.
We all, if we are serious or consider ourselves pros and want paid, sometimes have to perform "punter stuff." That is STANDARD cover music proven to fit the requirements of the audiences and their expectations.
Most performers at some time or another reluctantly have to perform material that they do not really want to perform at a time when they would prefer to be somewhere else and in a place they do not really want to be. It goes with the territory.
I have had arguments with folk that say they will only play what they want to play when they want to play it. This of course is utter nonesense and they are kidding themselves on. They are eitherjust hobbyists out for self gratification and ego boosting or are selfish ignorant folk who have no respect for an audience.
Any job requires people to do things they do not really want to do. The mark of a true pro is to oblige folk by giving them what they want when they want it.