OP ís completely rigth. I get the defensive point of view that SC4 went trought a long journey for mote than 10 years to become what ís it today and we should give this game more time but his major complain ís not the lack of key features but the general design of the game.
It's a casual game with no depth whatsoever, even if modders add 238384 new hospitals and clinics the simulation of health, average death age etc ís will still be crap.
The same with polution, traffic, education... The simulation ís just not there, it's a build your fancy city and don't worry for anything.
And I have not even started mentioning all the features that are missing, monorails, canals, beaches, night-day cycle, more densityclasses, buildings with non regular shapes .......
All that stuff likely can be modded, so not really sure what you are talking about. It isn't just assets that can be modded. I feel like some of you misunderstand what this game being a base actually means and improvements will constantly be made.