How about some place along the shores of Lake Michigan?
We stayed at a cottage on the grounds of this property and felt that it would be awesome to rent out the whole property for a multigenerational trip. It's within walking distance to the lake beach.
https://www.elephantwalkresort.com/