My first thought is somewhere on Lake Michigan, but many of the smaller resort towns don't have large chain properties. Those that do include Traverse City, Petoskey, and Holland.
In Traverse City, the bay is warm enough for swimming and if you want to really get away from the crowds go to Sleeping Bear. Saugatuck would probably have fewer families, but accomodations are small motels or B&Bs. The Lake Huron side is less touristy. Lake Erie beaches just don't compare to Michigan or Huron.
PS: Don't be surprised if this gets moved to the midwest forum.