If you build it like an eyesore, it will be an eyesore, yes. Here is a multi-story building that I lived as a student in and it housed another 10k: https://www.ruseducation.in/wp-content/uploads/2022/01/LOMON...
But I agree that building glass+concrete rectangles is a not a great idea for tourist spots (or anywhere, really).
When they were young, my grandparents moved into a whole district built from scratch for the purpose of housing workers from a nearby steelmill.
Communism notwithstanding, the district is amazingly well planned and - what's dearly missing in modern, hyper-optimized construction - sufficiently spread apart.
Exactly! If you rise up enough, it becomes possible to have green zones around these big buildings and make living actually enjoyable.
On the other end of the spectrum is Hong Kong and most of Manhattan - I don't look forward to living there, even if some condos are really nice inside.