In a word, fabulous.
For years I visited Dead Horse Point State Park, but only last year after I bought a camper van did I stay there. Undeniably one of my favorite places. It’s a little pricey to camp, but worth it in my opinion. Bring water as there is none at the two campgrounds. The restrooms are clean with flush toilets. Hiking is over the top spectacular on the trail adjacent to the campground.