I lived in Dubai and Abu Dhabi and I found it increasingly intolerable the longer I stayed there.
Not all maids rooms are bigger than a box room you'd give an au pair. Every apartment I lived in had windowless holes as maids rooms, and I didn't live in shitty apartments, far, far from it.
I didn't have a maid but most of the people I was friends with didn't have miss either - cleaners occasionally was the preferred choice. The people I knew who had a maid would tell your they loved their maid, that their maid was their equal, part of their family etc etc. yet the maid wouldn't be living in one of the spare rooms. The maid would be in the windowless hole, with one day off a week and their passport kept in madam's safe. I did view a few villas with outside maids rooms but they were always far from salubrious.
I loved the lifestyle there but hated the place. Glossy on the surface and a hypocritical mass of contradictions and questionable morals underneath. I loved living on the beach, but hated the racism and the way that people would happily spout extremely racist views as if it was normal. I'd hate driving to work down the extremely dangerous roads knowing that I'd pass signs to "labour camps" signposting the way to the hideous hovels that the Pakistani and Indian men would live in.
I hated being cheated by estate agents, the energy company, the TV/internet company. The awful sexism I encountered at the initial local company I worked for and the subsequent Iranian company I worked for. I was a senior member of staff yet there were all sorts of little prejudices, from not getting the school fees on time ("woman get fees at END of year, man get fees before term" etc) Most of all I hated the apologists, the people who pretended it was all ok, that it wasn't a grossly unfair society, that it wasn't actually downright dangerous there, that the jails weren't full of women whose sole crime was debt, or pregnancy, or about to be deported because their husband has falsely accused them of adultery/working without permission. My friend hasn't seen her daughter for six years because her husband falsely accused her and abducted their daughter. Her british husband. She was arrested and deported and is fighting like hell to get her daughter back. There are people who pretend things like this never happen, that it is a crime free society. It isn't.
If you go, go with eyes wide open to what actually happens, beneath the surface of respectability and glitz. My friend (who lasted four years there) always said that the UAE didn't take tax, but took 40 percent of your soul and he has a point. That what it felt like to me.
There are people who will say I'm not giving the true picture, that they are helping people out of poverty etc. That it's a great life. That's their opinion and they are entititled to it. I honestly couldn't stomach it past two years.
Good luck in whatever you decide.