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.