I've tried Legacy, but I get sad whenever a child grows up and leaves the house. I only get 2 generations in and then I stop. I usually resort to the following:
Tiny House Community - I converted Willow Creek into that, fitting 2-3 houses on each lot. It was fun creating all the different Sims and storylines. Although playing on one lot was funny. Sim A from House 1 would take out food from their own fridge, then try to use House 2 to chop the ingredients. But I put locks on all the houses so everyone stayed in their own house. Which didn't work, since Sim A wouldn't go back to their own house and use their own counter space to make food. So I have random cutting boards left in the grass that I find later.
Big Brother No Eliminations - Make a huge house in Del Sol and fit at least 20 Sims in it. Despite me maxing out their Cooking and Handiness skill levels, they stuck to snacks from the fridge and never fixed broken appliances. Also making sure most of them had the Neat trait didn't make them clean up after themselves. And of course things got messy in the romantic department. One day everyone's in love, the next day everyone is crying under the covers because they were in love with a player.
I want to do duplex and triplex communities for women and children. But I've taken an indefinite break from the game.