We love
Portal RV Resort in Moab. They have quite a few sites, and they also have sites they are trying to sell. They rent out those at the same price, and they are awesome sites.
The managers at Portal also have a Jeep tour company called Outlaw Jeep Tours, so they are very knowledgeable of the trails around the area. They can also hook up rafting and other adventures.
We have also stayed at Archview, which is north of town. It is a fine place to stay, as there are a few trail heads very close (7 Mile was a lot of fun - good solo adventure). Running into town isn't so too far, but I like staying aired down and disconnected on my swaybars while I am there, so prefer staying in town, closer to food and trail heads.
We have also stayed at Spanish Trail RV park. Very nice, and on the south end of town. Great park and close to stuff.
Have fun - totally jealous!!
kev