We also spent nearly a week last summer in our trailer at Ridgway State Park. You can choose RV sites with full hookups or electric only, depending on which campground you select. We chose the electric-only campground because we liked being above the lake in the pinon-cedar forest instead of being below the dam on the river. Very nice campgrounds with paved back-ins and pull-throughs, flush toilets, and convenient water and dump at half the price of a KOA.
We would also highly recommend a campground south of Telluride that the Forest Service has completely redone. It is called the Cayton Campground, has 30-amp electric, water, dump, and flush toilets (very popular, so you will definitely need reservations). It is located a few miles south of Lizardhead Pass on CO 145 at the intersection with the Bolam Pass Road. Bolam Pass is a very scenic and relatively easy road to the pass from CO 145 in a truck, but is almost impossible from the east (Durango Mountain Resort on US 550) in anything but a high-clearance 4x4, an ATV/OHV, a trail bike, or a mountain bike with a very fit rider. We traveled over it from the east end last summer in our Nissan Frontier (without our trailer obviously) and I wouldn't do it again.
If you have, or plan to rent, a 4x4 to take on the many jeep roads in the area around Ouray/Telluride, start with ones like the Ophir Pass Road (turn east off CO 145 just north of Trout Lake) and Engineer Pass (Silverton to Lake City). If you don't have a 4x4, two scenic drives we would recommend for a 4x2 pickup or sturdy toad would be the Last Dollar Road between Sawpit and Dallas Divide and the Owl Creek Pass Road from US 550, just south of Ridgway State Park, to Cimarron on US 50 between Gunnison and Montrose. From Cimarron, you can easily loop back on 50/550 to either Ridgway or Cayton.
It's gorgeous country, so you can't go wrong unless you find yourself on a jeep road that is more than you can handle (ie., I suggest staying off Black Bear and Imogene Passes!). And, if you stay at Cayton CG, you can easily do Mesa Verde on a day trip. If you go to Mesa Verde, we highly recommend stopping at the Anasazi Museum just west of Dolores. It has great hands-on, interactive exhibits that most kids will be fascinated by. Have a great trip, wherever you decide to stay and whatever you decide to do!
