Oh, it would totally ruin my everything if I deleted my Mods folder!!! Such a nightmare, I feel with you! So much of my game would not be possible without mods - and I'm mostly thinking of CC not really game tweaking mods. My royal palace and high nobility have their lives based on items in game only thanks to CC. I've also created additional swatches, ie stuff with coat of arms emblems for the top nobility houses.
Well, my Mods folder is "only" 10 GB. I try to be strict when downloading. If CC comes with tons of swatches (thanks to the creator it's easier to find favorites!), I'll delete many of them to reduce the GBs... They easily sum up, those CC files! I constantly plan to do some cleaning up, like moving CC that I never use out of the game folder. With a file name that makes sense, I can put it back in for a certain story or setting.
Btw, I'm on a low end computer. It was low end 6 years ago, so these days it might be even lower, LOL. It's a miracle that my game still runs :)