The Sims that I keep, manage to take care of themselves just fine after they learn how to. I have had quite a few Sims that would rather play the violin until they pass out or wet themselves. This group also tends to cancel almost anything that I direct to do in favor of dancing, washing their hands, browsing a book,, or letting their bladder, hunger, or energy go red before they take action. This group never lets Fun or Social go slightly below full. Sims in this group very often become random townies or they're just deleted. I've accumulated a group of Sims that has consistently had good or great AI so I use them for everything.
There is currently a problem with basketball hoops. Sims will stop painting or cooking to run outside and play basketball. That's on Maxis though not the Sims.
My advice - get rid of the stupid ones. Or if you spent a lot of time in CAS perfecting their look make a genetic twin first and then use MCC to copy/paste the original onto the twin. I have had several genetic twins that turned out to be a lot better to play than the original base Sim.