Wow, 200Gb, huh... I would go insane, and I have a lot. I stay around the 93-95GB mark. Literally just spent the day refining my mod folder with a new technique. Yes, I use those programs you mentioned religiously, but I also have Sims4TrayImporter. Add it to your process! Huge. Basically it reads the cc for any lots and households. Ex: if you have broken CAS cc (question mark skin), then equip the bad cc to a dummy sim, save to your gallery, then use this program to locate those files. And you can quickly jump to the folder location of that CC. It also highlights conflicts, but still use in tandem with the other stuff too. Assuming you have this program already though if you plan on uploading tray files.I appreciate the advice! I'll definitely keep it in mind. My mod folder is about 209gb right now, so I have quite a bit of paring down to do. Maybe releasing individual houses would be a good idea once the basic organization is done.
I'm also using tools like sims 4 mod manager and sims 4 tray importer, so the actual handling and sorting of mods is no big deal. Lemme tell you, the mod manager is a god-send cause so many people have duplicate CC, just with slightly different names. Saved me a lot of potential overlap.
EDIT: Oh, you mentioned Sims4TrayImporter in your post, my bad. Still valid new technique at least for me. Also, use Sims4Studio! It can do lots of things, but also merge/unmerge mod packages. That might be helpful too!