You can play DNS games, but I believe the results will be far from satisfying. Even with low TTLs, some ISPs ignore (yes) the TTL settings to get better performance, and cache things for longer periods.
I have found the Round Robin DNS games always seems to give poor response when a node is down.
The only 2 solutions I have worked with are to use a loadbalancer in active/active mode, or use some cluster technology so the servers are in active/standby mode.
I think one could use a reverse proxy, but that would make the reverse proxy a single point of failure.
eugene