I wanted to love this game. I love this style of game and I loved the first one. But CS:2 is sadly a clusterfuck, and the response from devs has been lackluster at best.
Yeah, mod support would be nice. CS:1 had Steam Workshop support, which was great. CS:2 has nothing, because they want to completely control the mod ecosystem with a new tool. The excuse was to bring console modding to parity with PC, but that's already bullshit since they admitted that even when the tool is released, some PC mods won't work on console.
More worrying is the base game. The mods would mostly be useful to fix weird decisions by the devs. From my standpoint, you CANNOT LOSE the game. Have a city in the red? You get free "government subsidies" to bring you into profitability. Even for a good city in the black, it's like having millions of free dollars thrown at you. You can't shut it off.
Couple it all with a "simulation" that doesn't seem to respond to user choices in any meaningful way, a UI that lacks a ton of shit the old game had, a lack of animated assets, etc etc... It's a shit show.
I'm sorry I bought it on good faith. I knew shit was gonna get wild when I pointed out what seemed to be a glaring bug on their forums (garbage trucks coming from surrounding cities to clear out my city's garbage -- FOR FREE), and was met with the dev tagging it "by design". Oh boy. It's a city painter, not a simulation.