To be fair, we really need a better way to manage mods. Throwing hundreds of folders in “Community” with no naming conventions and no way to organize is asking for trouble. As you say, it will only get worse.
At the very least, we need the ability to create subfolders. At least that way, we can enable/disable dozens of mods at once during troubleshooting.