I know two sets of people who have lived in these communities. One of them is my sister, who has lived in Shanghai, Beijing, and Hong Kong for the last 20 years, and she has three kids. Her kids go to the best schools, indeed her company now owns several international schools and prep schools for wealthy chinese kids.
The other is a college friend who lives in Oman, all taken care of by Nestle.
They both make orders of magnitude more money than me. I don't spend a second being jealous of them, it doesn't look appealing, not when we've visited, not when they talk about it... never really.
You're right, having money helps you be happy. It tails off when you've got what you need though, which in my opinion is less than most people think. Every rich person I know needs time more than money. Time as a family, time with their kids, time not working.
I would generally rather avoid any situation where I'm alienated from a local community. Whenever we go anywhere for a significant length of time (months to a year), we look for our kids to participate in the same systems that the average person in those countries does. And, if I couldn't bear for my kids to go to those schools (and I worry about that where I live right now down the line) then I don't want to be in that community. I don't want to side step by shunting the kids into a bubble. International schools are colonial institutions. I'd rather live somewhere where the society at least attempts to function for everyone. It's part of why I want to live here less and less, and spend more and more time away.
It goes for everything too. My wife turned down a really cool opportunity at a lib arts school that was quite experimental where all the faculty families lived on campus. The benefit to this financially was insane, but all of a sudden a huge amount of the pull of your social life is coming down from your place of work, no matter how well meaning. I have a friend who worked at google in the bay area and took their busses and went to their gym and it really fucked his life up. It was so incredibly lucrative though! Kids at the same school as your coworkers, seeing them socially all the time, all existing in a society that is at best an adjunct to the culture? No thanks.
What do I know, though? Im probably too poor or drunk to really render a respectable opinion.