I've been to this campground twice now, and had very different experiences.  

The first time was memorial day in 2019, and we had a great spot right on the water.  We took our canoe and were able to launch from our site.  So ideal.  It was relatively quiet, and nobody immediately near us.  Amazing sunsets.

The second time we went was June 2020.  This time we stayed on the other side of the lake.  The water was super low, so our view was completely dried up.  Also, it was pretty noisy with sites cramming several tents onto their sites.

Either way, on both occasions we the site relatively last minute, maybe a week or two in advance.  Any Californian will know it isnt always easy to book last minute campsites, so I appreciate that!  There are 100+ campsites there, so it seems like always something available.  Plus, not too far from the bay area.