Cities: Skylines is not too bad in that regard. The core game has some really silly assets (like the international airport which feels big until you realize that the runways are about ¼ or less of the proper size, and the concourse and terminals are scaled down to match), but for a lot of things you can build them to the proper scale with a little creative thinking, a DLC (like the airports DLC), or mods (get one of the parking lot mods so that you can put 10k parking spots around your realistically–sized stadium, for example).
Agreed! With just a little practice, building the perfect highway interchange with all of its flyovers everything is really a lot of fun. You can really see why cities like to build those perfect 6–level urban stack interchanges with access roads.
Yeah - the DLC really helps, where for instance a University changes from being a tiny building just a bit larger than a high school, to an entire campus with student accommodation, lecture halls, gyms, etc.