This is one of my favorite places anywhere; I grew up camping here and my dad grew up camping here as well. Camp Sherman has a cute little store nearby where you can get ice cream or snacks. The charming town of Sisters is nearby if you want to explore or go out to eat.
Canyon Creek is basically two campgrounds in one: there are sites along the creek and then there are sites clustered at the river. The creek sites are spaced out along the road as you come in; you will see little “driveways” along the creek as you come in. They can be tricky to access and I wouldn’t recommend taking an rv or low-clearance vehicle into some of them without careful scouting and an honest appraisal of your ability to get in and out. Most of them are fine but it’s definitely not the place for a 40’ trailer.
Creek sites have more privacy and seem to stay a little cooler. Some of them have downed logs or rocks that you can use to cross the creek and explore the forest beyond. The creek is painfully cold but if you really wanted to, you could cool off in it (I would recommend making a day trip to Suttle Lake or Scout Lake though if you really want to swim).
The other set of campsites are clustered around the river. They are pretty close together and can get pretty dusty during the summer months. The river is beautiful though and excellent for fly fishing.
One thing to keep in mind is that the river has incredibly strong currents and some serious rapids. If you have small children, it could be legitimately dangerous if they fall in regardless of whether they can swim. My family has been camping here for generations and at least one child in each generation has fallen in while fishing and had to be rescued by some very quick-thinking adults. I could see it being a little stressful to camp in one of the riverside sites if you have active kids with you.