I have stayed at several places in/near Moab. OK RV park is not far from Spanish Trails. It is a little off the highway. Overall, I found this campground to be fine. I've also stayed at Slickrock Campground a few times. This one falls into the "fair" category. It has trees which helps quite a bit. The infrastructure is old. 30 Amps instead of 50. Bathrooms were not good. It does have a small pool. It is usually one of the last CGs in Moab to sellout. It's fairly close to Portal.
If you don't want/need to be social, I have also stayed at Horse Thief CG. No utilities and a good distance from Moab but a very enjoyable CG. Desert Mesa.