We have stayed at these Kentucky State Resort Parks and found them to be really nice. There is tons to do and entirely kid friendly. Since the southern half of Kentucky is dry (no alcohol) the parks tend to be quiet and friendly. The lakes these parks are on are massive natural lakes.
