@PK99 Obviously Hopewell Rocks are the biggest draw in the area (and more than live up to their reputation) but it is a bit of a walk to them from the car park so I’d understand any reluctance to do a re-visit - e.g. once at low tide, once at high (we only had time to do them at low).
Thankfully there are other areas less talked about where you can see the dramatic tide changes without as much effort, notably the Sea Caves and the Covered Bridges in the village of St. Martins and also the Harbour in the town of Alma (had a great meal there at the Tipsy Tails).
We didn’t get to do the drive along the full length of the Fundy Trail Parkway (one of the things partially closed during the off-season) but that does come highly recommended - the road itself is very picturesque but there’s further treasures if you stop at the various laybys and just wander a few hundred yards down the trails - so many people miss these as they stay in their cars.
Moncton itself is just a standard provincial town with an excess of hotels for its size (in winter they’re all empty, in summer probably you can’t get a room for love nor money!) that is good to use as a base but you probably won’t need to spend much time there. However we did have a few good meals there (Tide and Boar Brewing Works stood out) and there’s a nice riverside path to explore. It goes on for quite a while and is apparently great to cycle on (in the city it’s paved, rest is easy flat gravel) but there were no bike rental places open when I was there unfortunately - you may have more luck in July.