I've been there a number of times
and it's pretty fun. Of course, like all those places, it ain't cheap. There is a water park just down the road a mile or two, "Water Country, USA", which is a REALLY nice water park. If you're going to be in the area a few days, you might try one of the bounce back passes so you can go back and forth.
Colonial Williamsburg is pretty cool, especially if you like history (which I do). It's pretty amazing all the restored Colonial buildings and there are a number of costumed re enactors running around the place. If you're going in the summer, I'll warn you, it's every bit as hot as Alabama, so bring sun screen, drink lots of water. Still, it's pretty cool. There is also a pretty nice outlet village in Williamsburg, so if you're married or have a girlfriend, they'd probably like that.
The College of William and Mary is on the edge of Colonial Williamsburg and it has some interesting old buildings. I seem to recall there are one or two that were designed by Sir Christopher Wren.
If you have time, check out Jamestown, the first permanent English settlement. It's not too far from Williamsburg, and very cool in it's own right.
If you have A LOT of time, there are a gozillion Civil War battlefields in and around Richmond. OK, a slight exaggeration but there are quite a few.
Anyway, I hope that helps. If you want to know anything else, let me know.