Ultra-deep Keck/MOSFIRE spectroscopic observations of $z\sim 2$ galaxies: direct oxygen abundances and nebular excitation properties