From nightlife to outdoor activities to iconic attractions, these eight cities offer the most thrills, according to a new FinanceBuzz study