I have tried many different Clubs, including
Fight and woohoo Club. It was when the Vampirepack was new and I used it. Clubmembers were not very impressed by their Club though.
Household Club were all 8 were best friends and best lovers. All members were best friends with all and all the others were their best lover. Very demanding time with countless problems to be solved. Player Trait is not waterproof.
Lovers Club where Club boss was romantically involved with all members and it worked well. There was no romantic activities on list of Club activities, instead it was focused on wellness, catching frogs and playing guitar. One time there was 3 or 4 pregnant members, so just getting together took some time, hahaha.
Family Clubs, where active sim is hanging out with their children growing up in other households.
Ad hoc Clubs for one time events migt work well. Your group will stick together as long the meeting is on and if it served the purpose, maybe remove that Club and form a new one for the next game mission.