One of the times where CNAME records can be useful is when you want a subdomain to point to a computer outside of your domain. For example, you might want "news.example.com" to go to your ISP's newsserver. Instead of putting in the IP address, you could put in "news.example.com CNAME news.myisp.com", so that if the IP address of the news server changed, you wouldn't have to make any changes.
It is also said that CNAMEs may be useful when you are renaming a host, and will later get rid of the current name [RFC1912 2.4].