I don't have a family yet and am going to live in an apartment regardless, so why not have one with a great view?
Obviously tall buildings make sense in places like New York where there are more people who want to live there than available dwelling units.
I guess different cities have different distributions of building heights, but living in NYC I feel like this is accurate living on any floor <10 and inaccurate on any floor >=10 (roughly). Even in the densest neighborhoods the fraction of tall skyscrapers is pretty low so if you're 10 stories up you'll usually be able to see pretty far even though you're still surrounded by much taller buildings.
I feel that other cities might tend much more to the 'walls of nearly identical height buildings'.
Stone henge, pyramids, etc
It's not rational, but it is pretty fucking cool