It's just an illusion. Lots of buildings and not much else. They dont allow you to live there as a retiree and you cant hug or touch your girlfriend/wife in public without going to jail. Maybe there is money to be made there, maybe not so, but I know I would not risk putting any of my money into it in case I dont ever see it again. As it stands its a dusty construction site and all the money has gone from it now. Its far more worthwhile buying property in Singapore or Hong Kong.
Well you are correct about the retiree bit.

Look at the big picture, what we (Expat buyers and western banks) are doing is building homes for the thousands of regional Arabs/ME citizens displaced by our acts of aggression.
These are people ethnically and culturally compatible for developing the small Dubai population.
It's a small price to pay. I do hope it works, sooner rather than later.