Kellydizfan, I think we may have been in Williamsburg the same week - we were there July 3 to the 10th. That was some ferocious heat!
Our family normally vacations at Disney in August, but VA was beyond what we have experienced in FL as far as heat. We actually came home a day early and heat was a big time contributor to that decision.
The ticket deals for the area are really super compared to Disney prices. We purchased the colonial area, BG, waterpark tickets which were $98 for adult tickets and child tickets were $82.
Couple of points that made this a really good deal.
-tickets are for unlimited park use for one week (essentially park hoppers)
-ticktes include unlimited parking at parks that have a parking fee
-kid tickets are for ages 6-17 (vs disney's 10 and up adult fee)
-kids under 6 are free!
We did have an enjoyable time. No, this was not disney (and we compared many things to Disney, trust me!), but it was a nice family trip at a very reasonable rate.
Things I recommend include a meal at a tavern in the colonial area (we really liked the King's Arms), the BG firewords show (very nice...comparable to Disney with music and all), the Irish dance show at BG, and if you have small kids the Elmo meal - really, really well done when we attended (surpassed many of the Disney character meals and we have done them all numerous times).
Last thing I would recommend because it was something we really loved - rent a cabana at the water park. The cost was $170 and worth every penny! In comparison to other places that rent cabanas, this is really reasonable and it includes 8 towels (yours to keep), 16 drinks (kept cold on ice in your cabana all day..water, pepsi, diet pepsi, mountain dew), and sunscreen.
We enjoyed this so much that we actually splurged and did this two days. It was a great place to hang out, read, and play games in between water play. Our family spent two entire days at the water park from open to close...not something we would do without the cabana. They were very relaxing and fun days...in fact I am pretty sure those were the favorite days for all of us of the whole trip.