South-East Asia (Bangkok, Jakarta, KL etc) after the 1998 crisis was full of skyscrapers that were never even finished before the money ran out, the Burj Khalifa opened up just when Dubai's economy went into freefall, and Calgary is a recent example of skyscrapers being completed at exactly the wrong time: https://news.ycombinator.com/item?id=28873926
Keep in mind too that the Empire State Building was the tallest building in the world for 40 years --- it held the title from 1930 until 1970 when the World Trade Center towers exceeded it. (The Empire State Building topped out in September, 1930, well before construction was comleted.) Conventional wisdom long held that supertowers were lagging economic indicators and foretold recessions. There's some truth to that.
These particular towers are the architectural equivalent of cryptocurrency: valuable solely for their wastefulness.
I believe the OP's point is that when usable space in a building goes unleased, it makes it hard for the investor to turn a profit. Therefore there is no economic incentive to build a taller building.
I find this argument a bit hard to understand for another reason, though. If there is no demand for space, then why does anyone construct new buildings, and why is rent so high in places like NYC? It seems to me like there is actually incredible demand for space in dense cities.
That is added on to the fact that skyscrapers are also engineering marvels, and the cost per unit goes up quite a bit once you have to start dealing with those problems, compared to the much more standard 6 story building as an example.
An additional novelty factor is that actually supporting the weight of the tower will require different techniques (and significantly higher costs) depending on the type of land the desired build site happens to be on.
All of these things create something of a price floor for rents.