I used to take my son camping every year in upstate New York, Lake George region.
Rent a powerboat for a day...scuba dive the next...wilderness hikes...etc...etc...
We usually went for a week at the very end of summer, just before he went back to school.