I think this is a “choose your poison” scenario. Are you trying to evade fire, flooding, aridity, hurricane impact etc? There is no silver bullet IMO, you have to trade off the negatives. Somewhere with a natural aquifer, not too much surrounding forestry (maybe high deserts)