BORING! Just kidding.
Was there a couple years ago. If you are there for a full moon, you can watch the tidal bore come in at Moncton. Sounds boring, but if it is a good tide, guys will surf the wave as it comes in. It's pretty neat, I think there is a website that tells you what time it hits Moncton so you don't have to stand around watching the tide for hours... It's a nice drive to the Bay of Funday, and Hopewell Rocks is really cool as well.