The James Robb campground at Fruita is very good. Excellent facilities - we were there in September. You are close to the town and services, but have views of the must-see Colorado National Monument. Spectacular red rock scenery up there - don't miss it. We enjoyed several days there and visited a few of the wonderful wineries. It's like Napa Valley was in the 1970s - very welcoming at the vineyards for tastings.
We liked the campground at Black Canyon NP.
Agree about Ouray - great little town, 4J campground by the river within walking distance of town.