Here's one my latest works, I made the buildings using Jama Jurabaev's quick shape addon and scattered the buildings using geometry nodes. The matte painting was done using Adobe Photoshop.
Manual box modeling on the roof
Geometry node scattering on the roof.