Scottsdale may appeal to people seeking outdoor activities, city amenities, and a desert setting. Whether it is a good fit depends on the trade-offs that matter to you—and on checking current local costs and conditions.