Airports are undergoing an unexpected renaissance, turning from stressful no-man’s lands into attractive destinations in their own right.