Humans need space both inside and outside, and they need sun exposure and some contact with nature to feel well.
Living only between concrete, steel and glass takes its toll on the well-being.
You're right that light and sky visibility are finite resources that require more land. 100+ story buildings can feel oppressive to people. The question to ask then is why we allocate so little land to mid-rise development and force it all into Manhattan and small downtowns. That's the biggest reason we have such tall buildings there.
Do you have citations? Arguably, skyscrapers don't mean a dense city but a mega dense city.
So how is your life better if you live in a 20 million city VS a 2 million city?