It is, however if you set the DNS TTL to only 90 seconds and use a script to check the servers, automatically removing unreachable servers from the DNS and inserting them back in as needed - it's a very basic high availability system.
But yes, the main reason I do it is for load balancing -- you're exactly right
