For sure, if you can get into Cheyenne Mountain State Park that is not only the best in Colorado Springs, it is one of the best anywhere.
But IT IS HARD TO GET A RESERVATION! And you have to have a reservation. I stayed there twice last Summer and was lucky enough to get a reservation in July, 2021.
Now, the KOA at Fountain is far better an any of the campgrounds in Colorado Springs or Manitou Springs--in my opinion. Most of the campgrounds in town are packed in. At least the campsites at KOA are reasonably spaced. I stayed in the KOA last September until my sites at Cheyenne Mountain opened up. This was because the September snowstorm ran us out of Rocky Mountain National Park.
So here is a clear recommendation: Cheyenne Mountain if you can get a reservation, otherwise KOA at Fountain.
EDIT to say: forgot to add, I did not notice road noise at all at the KOA.