Beautiful waterfront cities in America that tourists love