Mammoth Cave National Park for one. Also Land Between the Lakes Recreational area. Several years ago, my sister was looking into renting a houseboat for a few days there for her family.
Also, don't be surprised if this thread gets moved to the appropriate US regional forum instead of TravelBuzz.