Auto-scaling is the ability (with certain cloud infrastructure management tools like enStratus-in a limited beta through the end of the year) to add and remove capacity into a cloud infrastructure based on actual usage. No human intervention is necessary.
It sounds amazing-no more overloaded web sites. Just stick your site into the cloud and come what may! You just pay for what you use.
But I don't like auto-scaling.