NYC is fairly high density. Has stopped building massive new skyscrapers and has water on two sides. It is also a tier 1 global city culturally AND economically. Its not really reasonable to expect to be affordable.