Before you get to Hopewell, there is a nice campground in St Andews, NB (Kiwanis Oceanfront Camping). It’s right on Fundy bay. Nearby is an island (Ministers Island) that can be accessed by an ocean floor road when the bay tide is down.
It appears you plan to be traveling in NB, so Alma is an interesting seaport town near Hopewell where you can see boats floating and on sea bottom a few hours later.
David White '05 Monaco Windsor
'16 GMC Canyon 4x4
Madison, MS. Retired