Home sales in the Great Lakes region are soaring as remote workers ditch coastal cities for affordable waterfront living.