Certainly not a great place. I didn't spend much time there outside the airbase as I flew in from Khamis Mushait most times, but what I saw was pretty average. Khamis is also a hole. 30mins drive from base to compound and is kind of weird having kids point at you cause you are white. Compound is very quiet now. Would be a decent place for maintenance as it is quiet.
I spent an overnight in Tabuk at a compound and found it to be a neat and tidy place, good facilities, plenty of expats and a few decent compounds at reasonable prices too. Friendly locals as well. Jordan is close too for those weekend getaways.