There are possibilities to get sites with limited water view. Has nice surroundings but sites are a little rough but should not scare you away. We camped here in a Motorhome.
Nice basic provincial park. The access to the Bay of Fundy tidal flats is the big attraction. Recent renovations on the top half now provide better sites for RV's than in the past. We camped here in a Travel Trailer.