I must be a bit deviant, because I enjoyed the heck out of a club I called "The Dancing Woohoo Masters" in which being a Player is an entrance requirement (and an adult) because the club activities are basically dancing, kissing, being romantic, and having Woohoo indiscriminately.
Another I enjoyed making, but soon realized there were big problems with, was Fight Club. Because "practice fighting" wasn't an option in the list of social activities, I could only use "fighting" and the problem with that is, Club members end up hating each other, whereas friends can Practice Fighting and laugh about it after, which is what I would rather have had.
Based on my success with The Dancing Woohoo Masters, I made a similar one for teens only, in which doing homework and listening to music were club activities, but so were romantic options up to and including Messing Around. This one is harder to avoid drama with, unless I make sure all the teens in it, are also Players (can do this with cheats, and might be able to do it without, but it's hard)...but if anyone loves the idea of drama, heartbreak, and fights, having a teen dating/flirt club in which teens engage in promiscuous behavior but can become jealous or miserable, is a surefire way to do it!
I also haven't done it yet, but would have some fun with a club for either only Evil Sims, or Evil and Mean, only, to hone their skills at Mischief and Mayhem. But the Renegades can become this if you play Max Villareal (who is the leader) and change the club to stop Vandalizing, because it really is lame to hang around a public pool for long, when your own people have broken all the toilets, and sooner or later the same people who broke them, gotta go to the bathroom... kind of short-sighted, that vandalism.