East Midlands town is unexpected winner in a search for the best places for affordability and quality of life. Its proud residents explain why they like it