On Calabi-Yau and singular K\"ahler-Einstein metrics asymptotic to cones, and Hermitian-Yang-Mills connections on some complete K\"ahler manifolds