I'm a 20-year experienced system administrator with at least 13 years being spent with IP networks. So, hopefully I do understand pros and contras of DNS round-robin.
Seriously, my case has no other solution because it's gonna be two systems being placed in different geographical locations. Solutions which make use of a single IP for high availability are not of any use in this case, unfortunately. I don't know how does WM resolver works. But in hope that it's based upon standard Windows routines I would expect it to support multiple IPs per DNS entry. What would be expected from a client in this case is to remember all of those IPs and try them consequently one after another until a successful connect could be done. Or, if WM resolver does it in a proper way, a client would try to re-resolve an address every time a connect attempt is performed; this way the job of changing IPs would be done by the resolver itself.
As an example you could have a look at google.com. It resolves into three IP addresses (might be different for other locations). Every time one tries to ping this address he pings another IP.