I have stayed there quite a few times with family over the past few years. It is one of my favorite parks because it it close to home.
The spot you are in is open with little shade but you don't have anyone close to you and the yard is quiet, you can get a look at it from google earth. It also backs up on the freeway which may be a bit noisy, we like to stay down on that side of the campground, it usually is more quiet as far as the amount of traffic in the campground.
That being said, most times when there are events they stay way down at the end of circle. Most times they are small groups and quiet,and during the week that end of the park is mostly empty.
You say you have dogs,just be careful when walking them near the river in the thick brush, our friends let their dog loose in there and came back with ticks. Other times they were there and stayed around the campsite there were no problems.
Any other things just PM me.