A photometric and spectroscopic study of the brightest northern Cepheids — III. A high-resolution view of Cepheid atmospheres