Radio transients from compact objects across the mass spectrum in the era of multi-messenger astronomy