Thanks for all the info guys.
The camping gods had another plan for us apparently. We loaded up the car (2hrs) then packed a 2 & 4 year old in and headed to the park at noon Friday. We arrived at the park by 3pm and the whole thing was full. Next we decided to try Rock Island and it was stinking full. By this time it was around 5-6pm and the two little ones were hungry/been in the car a long time. Grabbed a McD's in I think Sparta before hitting 40 heading to either Bledsoe Creek or Cedars of Lebanon. Looked up Cedars and there was a VA reunion so Bledsoe it was. We finally pulled in around 830pm or so at an open spot in Bledsoe Creek State Park. I set up the tent, everyone laid down after a long exhausting day in the car and around 1am the rain came. Temps dropped to down right cold for little ones and our flipping tent leaked. I packed the girls back in the car at 3am, threw the tent away and came home.
All in all we drove a tank of gas to camp for a few hours maybe 20 miles from my house.

Our family camping trip was not up to expectations but we made sure to fill the rest of the weekend up for them of fun stuff. Me and mommy are whooped... time for booze/hot tub then bed.