If I recall correctly in
THIS topic there's a very interesting discussion with lots of club ideas for GT from creator of Dizzy Isy save file (according to topic she has 118 of them).
I do not have that much clubs in my game but I find them very useful in many situations. Overall I use clubs in two ways. Clubs I do not control actively, existing mostly for play-pretend activities around different lots in town. Clubs I start with active sims to achieve certain goals be it skilling or a way to force them into certain activities.
Here are some I use:
1) A club for a pretend band (until we have real ones). I set a specific Bar as hangout for them so whenever another sim visits there's a chance these guys will star a "gig".
2) A couple of clubs for schools. One for kids and one for teens. So when I want to have a day with my sims in "school" out of the rabbit hole I can start classes with these clubs. Homework and skilling bonuses sure helps.
3) Clubs to imitate "employees" of various town buildings. For example I have a bank in my save and a club with PC activity and set uniforms. So each time my sim visits a bank they spawn there, change into their "professional" clothes and occupy all PC's I set at the tellers places. Making it look like they are really working there. Same works for false restaurants where you can have a club for "waiters" with set uniforms and cleaning activities. And so on.
4) Since we still don't have attraction sometimes I set a temporary club for YA's with activity set to romantic interactions to see if some of them will form any relationships.
5) Family clubs for chores. If I say want a certain day to be a day kids are in charge of tiding up the house or perform some other tasks from mom but I do not want to constantly push them with parenting I just create a club for this.
6) I play rotationally and I want to see some sims from my families playing certain assigned roles around town. I achieve this with clubs. Like I have a sim who I imagine is in a repair service. But if I hire a repair service random NPC will show up not my sim. So I've created a club for my Repair Man with repair activity who anyone can join. When another sim is in need of repairing he joins this club and start a club gathering at the home lot. My Repair Man arrive, do the stuff and then I just make active sim leave the club. And pay repairman money by giving him a money gift.
7) Club for my Town Council. So that they can held meetings and debates. Sometimes I control it for the story/skilling purpose, sometimes they just make my fake Town Hall look functional. Also since I use a limited number of moded club activities I can organize "spontaneous" protests there Sims3 style.
The only thing I fail hard with Clubs so far - I can't force (mods or no mods) my Sims to proper interact with dogs in what I imagine is a a dog park. It irritates me so much that all the training equipment no matter the Lot Traits is always only used by active sims. I've tried to solve it with clubs but they still don't use it.