The former Top Gear host says his views on Manchester have changed after eight years filming Who Wants to Be a Millionaire? in the city