I originally got it for one reason -- to stop the game from generating all the random sims. I have an older computer and felt that fewer NPCs meant smaller saves and better performance. Since then it's proven to be a treasure trove of tweaks and settings, large and small. I don't know what I'd do without it.
* Stop constant dish washing, getting glasses of water, anything else annoying
* Narrowing ridiculous shoulder widths on extremely fit sims (Hey Maxis, shoulder bones dont grow wider when you pack on muscle!)
* Changing walk style, voice, etc. of NPCs without loading CAS
* Pay bills automatically
* Get rid of romantic progress bar on sims that flirt by mistake
* Change into regular outfit after work
* Add/remove money, skills, aspirations, career steps
* Copy and paste body and clothing from one sim onto another
* Reduce total number of sims that can appear on a lot
And 1000 other things. It's not overwhelming at all if you just install it and then tweak each small annoyance as needed.
The one thing I did not like was when I first loaded up MCCC it had default settings to marry off NPC sims, put them into empty houses all over the world, and start making babies. I figured out how to disable all of this and started a new save, and since then it's been smooth sailing. My game saves are reasonable and I don't get crazy lag like I used to get all the time. I wish the default settings were completely flat with an opt-in for the auto-generated families, but it's not a problem.
If you are trying to run minimal saves, the other biggie is NPCC, which seems to work well with MCCC. If you want a certain sim to be the pizza delivery guy or mailman, this is your go-to mod. You can either pick the sim's new career, or graft the body and clothing from another sim onto an existing career sim using MCCC. NPCC also causes the game to re-use sims that you already have set up as bartenders, yoga instructors, etc., instead of creating several new ones for every job.