David Wallace-Wells put out 'The Uninhabitable Earth' which I think is supposed to be worst case scenario.

https://www.nbcnews.com/think/opinion/fighting-climate-action-uninhabitable-earth-author-david-wallace-wells-podcast-ncna979551

I often go back to this interview specifically for this moment:

I was talking to a really prominent climate scientist a few months ago, who was one of the lead authors of the IPCC last report, and has been doing a lot of consulting work in New York City where he lives. So I said, "Are we gonna build a sea wall in New York?" And he said, "Oh, of course we'll build a sea wall. Manhattan real estate's way too expensive to lose." But those kinds of projects ... You look at the subway, it takes 30 years.

If we started now, he said, we couldn't build it fast enough to save parts of Howard Beach, South Brooklyn, Queens. He said, "The city knows this, and you're gonna start seeing them stopping infrastructure repair, not doing work on the subway lines and even telling those residents explicitly, 'You might be able to live here for another 20 years, but you're not gonna be able to leave this house for your kids.'"

As far as I'm aware they still haven't started. From an article in 2024:

https://newrepublic.com/article/178452/clean-air-rich-luxury-good