Colonising deserts is much more doable and desirable than any onwater or underwater scenarios.
Onwater land-maintenance is expensive (boats, tanks, or what), for a desert that’s free. Desalination is needed for both. Desert colonies need water transported by pipelines, but so does New York.
Doesn’t rule out a onwater/underwater/inspace tourist resort. But there self-sustainability is not a real goal.
