Honestly, so far I feel like I am missing something else that everyone is seeing and liking about the clubs. I can see objectively where it could be useful for skilling, but it also strikes me as almost cheat-level easy where, like having too many focus items, it can lower the challenge to the point where as a player I feel no sense of accomplishment or enjoyment. (Kind of like how vampires skilled in Sims 3, although, to be fair, I haven't played a club long enough to see if it's that fast.) I can also see where it could be used for laughs, like forming a club that puts everyone in an silly outfit and makes them wander around town in it, but those are the sort of uses I'd only use once in a while rather than frequently.
Perhaps it's just not suited to my play style. I freely admit I don't like socializing in this game except very firmly on my terms. I get annoyed when strangers come up to my sims and interrupt them on public lots, and sim behavior from visiting guests like raiding my fridge, making drinks on my bar, or worse, using my computer (a peeve in real life) drives me batty. In fact, I had a mod in for a while that prevented anyone, even relatives and full green best friends, from trying to visit me unless I invited them over, because it seemed like they'd try to visit constantly.
I do really like Windenburg and a lot of the new items and clothing. Maybe I haven't figured out a good way to use the clubs to do things I like yet. If they were more temporary I'd wonder if they could be used to better stage screen shots for stories, but I don't know if there are social consequences for forming and deleting throwaway clubs. I haven't messed around with the feature enough, because I don't really see long-term what any sims I'm playing would do in one that wouldn't be redundant with what they already do. By that, I mean, they already have tons of focus items so a skill boost from a club because friends are visiting them doing what they are doing would just mean more sims in the way to me, with no positive to outweigh it. Unless the club does something extra other than making the skill grow even faster, which to me, I don't think is a good enough trade off. I'm also not particularly interested in them having more friends or higher relationships with friends as a goal. It's nice when it happens, but not something I seek out, generally.