Andy Cohen reveals how being in the spotlight has affected his love life