We've been to a lot of similar campgrounds in Oregon that are managed by the National Forest. These are basic, cheap (normally $10-$15), forested campgrounds right off a highway that offer basic amenities such as water and pit toilets. Sometimes you get lucky and there's an amazing view or lake, or sometimes you're unlucky and it's noisy and too close to the highway.

In the case of Riverside Campground not too far outside Sisters, Oregon, you have both: spots on the upper-hill side are often right off the highway, to the extent that one side of your spot is literally a busy road. On the down-hill side, it's the opposite, with lovely green, forested sites right on the river. Both areas have noise during the nights from the road, but the spots closer to the freeway are obviously louder.

All in all, there's other campgrounds in the area I'd head to first (the Marion Forks fish hatchery campground is pretty cool), but if you're going to stay here, choose your site wisely.