Forested Campground in Willamette National Forest on the banks of a river. However, location location location. If you camp here you’ll want to get a spot on the river side and you can hear the rushing of the creek.
However, the whole campground is right next to Highway 22, so even if you are lucky enough to be camping on the river side and hearing the river you may still hear the freeway. If you are stuck on the inland spots you literally can walk out of your tent and onto the highway within 10 feet.
Drinking water available on site along with vault toilets. Mostly tent campers and small RVs or trailers. Very cheap as its on National Forest land.
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.