We have spent many days along the coast there from SF North. We did not care if it was windy or foggy.
It's where I was born and raised.
We really liked the state parks at Sonoma Coast states parks the best. Wright's Beach was a favorite. Small but if you were lucky you could bet right on the beach edge. We also loved the Russian River area and all of that section of the coast.
The only problems we ever had was starting in the '80s it got increasingly hard to get a spot on the coast with very few parks and the numbers of RVs that we sold.
We sure miss the salt water now, but we will hit the road soon full time and we will get back to it.