The town topped Scotland for wellbeing in the 2025 Best Places to Live report, but scored low for house prices, connectivity or natural environment