The Bay of Fundy National Park is the highlight of the area. However it is outrageously expensive as the charge you to enter the park and then charge for the camping above that. So plan a day trip to that park.
The Hopewell rocks and the tide flow at that area is something to see. Plan to be there at or near low tide so you can go down on the beach.
Not sure what your schedule is but if possible go to PEI and or Nova Scotia rather than New Brunswick. If you do you will know why I said that.
WBCCI 12156 AIR 3144 WACHUNG TAC NJ6
2004 Excursion 4x4
1991 34 ft. Excella +220,000 miles, new laminated flooring, new upholstery, new 3200 lbs axles