How are buildings in NYC designed with an expectation that they will flood? I haven't seen much of that, especially pre-Sandy. Post-Sandy there are some buildings with mounting brackets for walls/sandbags if there's another flood but that's not really designed in.
There are ways to mitigate the risks of living in a flood plain while still reaping the benefits.