By "most," I mean most enjoyment.
It's designed for legacy-type players who want more drama in their game. That said, you can still have fun with it even if you're not doing a legacy.
Want to see more fights in the Spice District? You can use this cheat on some of the Sims who show up regularly in the area:
testingcheats on
traits.equip_trait Argumentative
You can cheat as many as 5 character traits on the YAs, Adults, and Elders that your Sims interact with.
Do you want your Sim to have more of a personality? When making a Sim in CAS, you can skip the neat/slob, good/evil traits, and use the above cheat to give the corresponding character trait. Or maybe you want a Sim who enjoys cleaning and has a gassy digestive system -- neat trait + Bad Manners should accomplish that.
As for people doing dynasties -- if you're going for the Hall of Fame, I'd recommend playing with a test family for a while until you figure out how to deal with phases and mood swings. It's probably going to be harder to get your child heir to max all 4 childhood aspirations before aging up. But once you figure out how to instill responsibility, those job promotions should be a bit faster.
Finally, this pack is a real boon to those of us who like to play ISBI (I'm Surrounded by Idiots) challenges, in which you control only one Sim in a household. As you develop the parenting skill, your Sim will at last be able to tell teens to do their homework and put children to bed at a decent hour. Parents can even give a small boost to hygiene and other needs for their children. If you tried the Asylum Challenge before and found it too dull, you can use the cheats to make inmates Argumentative, Bad Mannered, and Irresponsible, with Uncontrolled Emotions. If you want a real challenge but don't want to commit to a full legacy, try an orphanage challenge with 7 (or fewer) toddlers. Last but not least, there's our own Ten-Gen Townie Dynasty.
There are other, smaller, things you can do as well, like make sack lunches out of dishes at a restaurant or left on picnic tables.