it’s dead flat and pretty hot. I’ve visited for work a few times, I could think of worse places to live for a couple of years but it depends on your circumstances. If you want nightlife you’ll probably want to fly to Dubai every weekend (1hr). Might be nice and chilled with a young family and the $$$$ is attractive. There is money sloshing around there like you wouldn’t believe. You’d probably want to forget about mtn biking and go full roadie.
Well it’s changed a lot and it’s improving all the time. It is much much smaller and quieter than Dubai (which isn’t necessarily a bad thing).
There are however a few good hotel bars and a few things to do but it’s mainly about the work and then spending your vacation elsewhere. Flight connections are pretty good, India/Himalayas is pretty close if you want to explore there, Oman is stunning.
EDIT: I have friends who live and work there and I visit regularly on businesses, if you drop me an email (in profile) I’ll put you in touch with them.