This is based on my (kinda limited) knowledge!
There's a big difference between script mods and CC. Script mods are mods that change the script (code) of the game, and doesn't add any content. For example, MC command is a script mod, liberated stuff are script mods, and most small gameplay changes are script mods. Script mods are usually safer to install since they only change the existing code, meaning if the game updates, the mods should change as well.
With CC it's different, for example if you've downloaded a chair that didn't exist in the game to begin with, that chair won't work with new actions that are added later on. Like how a lot of furniture got unplayable with Cats and Dogs, since that EP added the option for pets to destroy furniture.
So my recommendation is to only install script mods. Script mods are mostly about gameplay, but there are some "stuff" script mods as well. These are usually called "liberated ". They are things that are in the game but are not available in buy mode, not even with cheats. For example, I have installed plasticbox's "liberated rocks" and "liberated garden stuff". These are items that are coded for by Maxi, but weren't included in the gameplay for some reason.
Another good thing about script mods is that since they don't add any new content to the game, they don't really affect the loading time.
I'm fairly new to modding so take this with a grain of salt! This is based on my personal experience.
