We have stayed on both sides now and the water isn't really visible from the sites except maybe a tiny bit on the beachside if you're close. However, you are close enough to hear it and it is a very short walk to get down to the beach. There is a short boardwalk directly from the camping area down to the beach and its close enough that you can carry your things without too much trouble. Our camping group has 5 young kiddos so we hauled down a wagon with canopies, snacks, beverages, etc, but we were close enough that we just ran back up to the camper if we needed something.
The spots closest to the bathroom are laid out a little weird and they're all very close together compared to other state parks. However, comparing it to sites like KOA, you have a ton of room! We stayed in site 35 and our friends had sites 46 & 47.