Make your own experince
Hello!
Oman is a very nice place and the Omanis are polite with great hospitality. If you have the opportunity to join them, do it.
If you want swinging night life, look somewhere else. Living in the country side is not bad. There are lots of different activities for you and your family depends on what you are interesting in.
Give it a try and experience for yourself, you always has the possibility to resign if you do not like there for some reasons.
Regards
From an expat who spent 11 years in Oman and still visiting the country from time to time.