Super simple example of auto rotation, just shows it works in a very controlled setting. Auto rotation is only available for LINE layers. Check out the URLs for the images. They show how labeling properties can be changed on-the-fly.

map file

No rotation, position CC.

Auto rotate, position UC.
Auto rotate, position LC.