Houses built to the German Passivhaus standard would do just fine in Ohio. I used to live in Ohio and Western Pennsylvania, so I should know. There was one Minnesota church built with polystyrene panels that had to start running air conditioning in the middle of winter, the insulation was so good.
If you live in the South West though its perfect as Winter nights dont require much heat and the biggest loads are AC at the times when there is lots of sun.
It can get pretty darn cold at night in the desert southwest. Again, insulation is the key.
Of course water is the next problem, but cheap electricity can help that too.
It's 10X as expensive to use techniques like desalinization. It's so much more expensive, that lots of desal plants get built, then get mothballed because it's that much cheaper to get water by other means.