We stayed the night in Grand Falls, New Brunswick at the municipal campground. It was small but nice. We could hear the rushing water from our site.
I could go back there a spend more time. We were told that the water levels were low because the dam was being repaired. There is a zip line across the gorge.
http://www.grandfalls.com/english/fallsgorge.html
http://www.grandfalls.com/english/about/about.html