It's kind of outta the way to where you should be going, but if you're taking a trip to New Brunswick anyway, I would suggest the Hopewell Rocks:
http://www.thehopewellrocks.ca/
There's some decent hiking trails in Fundy National Park, which is in that same area too.
http://www.pc.gc.ca/pn-np/nb/fundy/index.aspx