For gameplay, I guess I prefer more of a legacy-style narrative in the sense that I like to follow one family through the generations, and the legacy challenge and its variants are a good source for inspiration on what to do with that family, but I've never been particularly serious about point-collecting.
As far as story writing is concerned, the legacies I read tend to fall into one of three gameplay styles:
1. Letting the Sims do what they want, basically just playing the game normally, documenting what goes down and then making a story out of it. This style includes 'true' legacies, which follow the Pinstar rules and aim to collect points.
The best story I've ever read in this style had an author with a great sense of humour who fully leaned into the wackiness of the game and used that to provide witty and entertaining commentary throughout.
2. Essentially creative writing using Sims to illustrate the story, where the narrative is pre-planned and possibly even pre-written and the game is just used to provide the visuals. Usually the visually gorgeous ones with ReShade effects and tonnes of poses fall into this category. I don't think I'd ever have the patience for this style of storytelling myself, but
one of my all-time favourites is done in this style.
3. A mix of the above two, where the author might have an idea in their head about how the story should go, but they allow in-game events to influence the course of the narrative. This is my preference and the style my own legacy story is written in, since while I like interesting plots and developed characters, I also like playing the game itself too much to just use it for screenshots.