The amount of energy you need goes up the less moisture there is in the air. The ideal conditions are moist, cool places with cheap electricity. Tropical conditions would have a shot at profitability, but you may as well desal whatever's already there than condense it.

Exactly this. Desalination and transport is aways orders of Magnitude cheaper and more efficient.

I don’t see this changing at any point in the near future. It’s phenomenally energy intensive to pull water out of the air in any quantity.