Okay... in a nutshell : Tidal bore on the Petitcodiac River... skip it. The causeway built years ago has turned the "Mighty" into the "Muddy" and the bore is a shadow of it's past.
Magnetic Hill... skip it. It's more boring than the bore. No indication as yet as to who will headline the big summer concert this year on The Hill... we've had The stones, U2, Lynard Skynard, etc.
Close to Moncton... Hopewell Cape, Shediac Lobster Festival (warmest salt water north of the Carolinas) but do NOT expect cheap meals during high season and traffic is a crawl. Parlee Beach at low tide is excellent (if you plan to go there, let me know and I'll give you a safety tip regarding "quicksand" which does occur in a few spots if you wade or swim out out in the water too far at low tide).
Oh... if you do go to The Bore Park in Moncton, be sure you see The Saxby Gale plaque... get eye level with the high water mark, look out across the river and imagine what a storm it was. Chilling.
You can google those names and Tourism New Brunswick, Nova Scotia and Prince Edward Island. Now, Newfoundland... fantastic, but you can't see it all, eh?
The ferry from Saint John to Digby can be fun if whales and porpoises are on the go. Other than that it's a 3.5 hour bore. Add 1.5 hours de/boarding and it's not a good gamble to possibly see some big trout.