We tried out Lake Anna this year, which was just perfect for us with the girls the ages they are right now. Two hours each way made for much easier travel than the usual four+ hours (well, except for poor Josie, who got sick on the way home), and the house we rented was really nice with great amenities.
[The first bunkbed that Josie ever got to sleep in]
Lake Anna is known for being pretty warm, and while it seemed like (almost too warm) bath water when we stuck our hands in the first night, it turned out to just be a perfect temperature when we actually got in: none of the normal shock from the cold water, but not so warm that it felt gross on a hot day. And going in June probably helped with that too, since while it was definitely hot out, it wasn't sweltering enough to make the water even warmer.
As I mentioned, the amenities were really great at this house. We took the kayaks and paddle boat out on the lake, although I just realized we didn't use the canoe at all. I especially liked the double row of lifejackets of different sizes that were available, all neatly numbered so that they could be hung up on the appropriately-numbered hook (the owners of the house were very organized. I loved it.). Watching the beautiful sunsets every night was great though too, particularly from nestled within a hammock with a passel of children piled on top of oneself. I'd imagine, at least.
[Josie's TV-watching face; I'm pretty sure she did not blink or breathe the entire movie]
Anyway! Vacation was great, and we got to spend lots of quality time together. I think we'll do it again sometime :)