It's called the Entertainment Business.
While it's very romantic to think you can have fun amd make money playing only songs you like, if you don't treat it like entertainment and business, then you won't be either entertaining or making money.
That means you have to put on an act and look like you're enjoying every number you play, even if you're not.
As far as our band goes, and I've said it before, if the audience at every gig are asking you to play something they know, then you've chosen the wrong songs.