If I had to summarise it I'd say: Dubai is a financial con-job built on debt and the exploitation of an Asian underclass. It is unsustainable financially and ecologically since when the money runs out so will the desalinated water.
I guess that in the future the Dubai natives will simply move into the abandonned hotels and shopping malls and the desert will reclaim the golf courses and ski slopes.
This poem by Shelly comes to mind...
I met a traveller from an antique land
Who said: Two vast and trunkless legs of stone
Stand in the desert. Near them, on the sand,
Half sunk, a shatter'd visage lies, whose frown
And wrinkled lip, and sneer of cold command
Tell that its sculptor well those passions read
Which yet survive, stamp'd on these lifeless things,
The hand that mocked them and the heart that fed.
And on the pedestal these words appear:
"My name is Ozymandias, king of kings:
Look on my works, ye Mighty, and despair!"
Nothing beside remains. Round the decay
Of that colossal wreck, boundless and bare,
The lone and level sands stretch far away