You might want to check out City: Skylines. Intuitive controls, deep mechanics, and thriving mod community. Some of the stuff on r/cityskylines is pretty amazing.
It's best looked at as more of a "city painter" than something which is going to be challenging to build a large, successful city in.