We visited in Early June this time, and this time had a campsite on the East side under the very, very tall pine trees (sites 32-47). Less privacy between sites, but a beautiful  effect.
Last time we camped in site 65, next to the path to the playground & walk-in site parking which was busy. You might want to choose a sit away from the pit toilets for the usual reasons, but also to avoid the light from the streetlights over them.
The river was low this time, so we didn't do any canoeing, but we saw many people tubing from Sugar River Adventures  having fun, Walking a tube over a sandbar is nothing compared to dragging a canoe.
BIGGEST NOTICEABLE DIFFERENCE there's a farm nearby that has Peacocks, and they screamed until well into the night. we thought it was bobcats attacking wild turkeys until the lady at the front gate set us straight. I hope this is only a seasonal mating thing and not a new feature.
One more note, biggest picnic tables we've seen, and our site had two.