Discover five of the best late summer trips for 2026, from Utah's red-rock landscapes to Rhode Island's historic waterfront