I think it depends on the child. I viscerally hated holiday clubs, with a couple of exceptions, but many of my friends loved them!
I'm autistic, and I found the group activities, games, and socialising embarrassing and uncomfortable. At one club I was lucky that the staff were happy to let me sit at the table and draw, but otherwise I dreaded the whole experience. I was surrounded by people I didn't know, who were mostly loving the whole thing, while I felt like an odd-one-out trying to force myself to join in and look like I was enjoying it. Of course I would have preferred to be home with a parent, but my single mother was working full-time and my grandparents needed a break every now and then. It certainly didn't give her any joy to send me there knowing I didn't like them, so I never had to go back to the same group two years in a row if I really hated it. Instead I kept trying new ones, and it kept me supervised and occupied while my mother was at work.
The exceptions were an art club I did for two weeks one summer at primary age, where we did different art activities in the mornings and afternoons. Everything was solo, and we could chat comfortably as we drew, painted, and sculpted. The second exception was a drama club when I was a pre-teen, which had games and group activities but took everything a bit more seriously. I never felt like I was embarrassing myself to participate, and we ended the two weeks with a performance we'd developed around the year's theme. I went back to the art club for two years and the drama club for three years, and I would have kept going if the clubs hadn't stopped running for various reasons. All of that is to say that I'd imagine most children would be able to find some kind of club they enjoy, even if it's not most of them!