We drove through Saint Vrain State Park a couple of years ago. About half of the sites are electric only, and the other half have full hookups. However, I suspect that the water may be shut off at some or all sites during the winter due to freezing temperatures.
During our drive-thru at the time, the campground was very clean, modern and secure. Also, there is excellent fishing in the Saint Vrain River. (This area used to be called Barbour Ponds.)
This park was damaged during floods in recent years, but relatives in the area say that the park is open, and campsites are in use. However, we have not seen it after the flood repairs were done.
Saint Vrain's Website: Colorado Parks & Wildlife - Camping