If you live anywhere in the US you're probably ok. The southwest droughts are bad but the rivers were overused even before climate change. We'll build more air conditioners and more levees. Those rich enough to move to Vermont will be fine anywhere.
The billions living in already marginal places near the equator will die or leave. That's where the real humanitarian disaster will be, and it will be far beyond precedent.