Check out the Village of Sayward
Sayward BC.
It is a small town near the water. There is a lovely campground in the village on a big pond with washrooms and a free sanistation.
If you drive past the Village you will come to Kelsey Bay where there are about 15 full hook-up sites right at the water. Last summer we saw a man land a 30+ pound halibut right off the pier.
The local community runs a lovely gift shop on the dock and there is a whale listening station there too.
An expensive trip, but to a beautiful location is a
Gorge Harbour Marina and Campground on Cortez Island. It is expensive to get there, first the Ferry to Quadra Island from Campbell River, then another Ferry to Cortez. Cost us $170+ for 4 adults and a 27 foot RV last summer. But what an incredibly beautiful location.
We usually camp at Forestry sites or Provincial Parks, Gorge Harbour is not our usual sort of place, but we will be back.