We thoroughly enjoyed our stay at Dennis Beach! It's a cute cabin across the street from Dennis Beach which is a large sandy beach about 3km long with gorgeous red sandstone cliffs and reefs at either end. We spent a whole afternoon playing in the water around the red rocks and watching the tide go out. The cabin is not that far from Hopewell Rocks, but we actually enjoyed Dennis beach to the famous Hopewell Rocks.
We were there at the full moon when the tides are the most pronounced (they are also large at new moon) and with some patience you could watch the tides rise and fall in real time. The Beach is public, but was always either totally deserted or had just a handful of people on it. The water (mid August) was warm enough to swim comfortably. We saw lots of snails, hermit crabs, and one other type of crab. In addition we found some remains of lobster. A local fisherman told us that seals sometimes rest on the beach, but we didn't see them on the three days that we were there.
We also went to see the Tidal Bore in Moncton which was really neat.
The cabin was clean, the kitchen was well stocked, and the host very responsive.
Other things to be aware of. The cabin is quite out of the way with the nearest city, Moncton, about an hour away. Also, there was no wifi, and cell service was marginal at best.
Highly recommend.