Upgrade an overnight in these cities with hip new hotels — from Amana, Iowa, to Fargo, North Dakota — that are destinations in themselves.