Assuming you are not looking for a quite, peaceful, experience away from road noise, this is a great campground. But as noted by others, it is right off of the highway, so you will hear some of that noise. As long as you know that going in, and for the right scenario, this still makes for a great base camp for lots of adventures in and around Sisters.

Or in my case, coming to Central Oregon for an extended weekend of activities, I like to have a guaranteed spot to camp that first night as it's about 5.5 hour drive for me, and I don't want to have to look for dispersed camping in unfamiliar areas while tired. After dinner and a beer at Three Creeks Brewing just down the road in Sisters, being able to pull up to a reserved spot was ideal. Clean, quite campground (besides the hwy noise), with large sites.

Again, it was perfect for my use case. One night after a long drive, before exploring dispersed camping opportunities the rest of my visit.
(Note: my stay was July of 2023. Really hot that summer, the shade from the trees were a big relief.)