I made a crude mod manager for the game: https://github.com/AyrA/CvModManager/releases
Run it, press “I” to install a mod, then drag the mod folder from SteamCMD (the folder that contains info.json) into the console window.
Installed mods are enabled automatically.