Leaving aside the qs. of human rights, migrant workers, etc* , we lived in the area (Abu Dhabi and Oman) for many years. Oman is certainly less touristy and much more spectacular scenery wise, but there is v likely more to amuse older children/teens in Dubai.
The general area is great for virtually guaranteed warm sun in the depths of the U.K. winter, plus nice beaches, and reasonably warm - or at least not 🥶 - sea.
When we were resident, lots of grandparents, inc. both our sets of parents, came more than once for Christmas and thoroughly enjoyed it.
*I would just add that many of the migrant workers in dh’s company came from India, and IMO were exploited most by the Indian agencies who arranged the jobs - taking a lot of their initial earnings, a lot more than seemed fair, as I heard more than once from disgruntled workers.
In the course of my job at the airport I had to reply to scores of letters from Indians asking for jobs - there was certainly no shortage of people more than willing to come for considerably higher wages than they’d have got at home.
I particularly remember dh telling me of a man in their plant yard (maintaining and fixing their many vehicles) who was doing a fairly menial job, but who had a degree and had been employed in a graduate capacity at home, but had taken this considerably better paid work in order to be able to save.