Transient searches for high-energy neutrino counterparts: the role of current and future multiwavelength facilities