I've come to realize that some Sims seem to be "smarter" than others. I keep the smart ones and use the others as townies.
I play with autonomy on except for when they have to read a book, paint a certain type of painting, cook a meal, or do something specific to a career. Right now even the smart ones, get distracted by a basketball hoop and will stop what they're doing to run outside to shoot a few hoops before going off to do something else. Is this the fault of their AI or is it faulty programming?
The first week or two of a new save what I'm basically doing is teaching them how to take care of themselves. I think this is what we're all doing. About two weeks after I start playing a Sim I notice that some will develop a tendency to override what I want them to do so I back off and leave them on their own for a few days. The "smart" ones manage just fine. They keep their needs up, including social by talking to plants or chatting online. I've never had one in this group pass out, pee themselves, or start a fire. They manage to repair things that break, take out the trash, and inspect their garden on their own. These are my keepers.
On the other hand, the not-so-smart ones are more concerned with keeping up Fun and Social instead of Bladder, Energy, Hunger, or even Hygiene. Sims in this group often have a red plumbob, pass out, and/or wet themselves because they ignored their most critical needs and ignored me when I told them to use the bathroom or eat. These are not keepers. They either get dead (one died in a kitchen fire), deleted, or sent "out of town" where townies are free to do whatever they want, whenever they want.
I've collected about eleven "smart" Sims who have started families. What I've found is that the AI of their children is consistently just as good, or even better than their parents. Another thing that I've found very interesting about this group is that all but one is left-handed. I was also surprised to find that four of them have the hidden "Likes Fruitcake" trait.
My Sims all start in the same Tier 2 Tiny Home Starter so none of them start with any extra advantages. They start with the Nerd Brain aspiration to get the Quick Learner aspiration trait. My last three Sims started with their lots designated as Off the Grid because I wanted to see if any improvements had been made to this lot trait. Yes and no (mostly no). There are still many candle lamps that aren't tagged for use off the grid. I was surprised to find that a card table can't be used off the grid. I guess the Landgraabs figured out a way to make a deck of cards function with power. Dartboards with twinkling lights must be powered too.