I currently live in Houston.
I don't drink tap water directly. It goes through a brita water filter. After that, it's generally fine.
As for too hot... I 100% agree. I'd move if I could keep my job. I want to move north where it's cold. But I don't want to move where people are.