Rumour has it that Comus is the absolute best script for this, though I haven't yet tried it.
http://nibbi.net/scripts/comus_thumbs.php
TGP Rotator can also do the job, and I am using it with some success on a few of my own sites
http://www.jmbsoft.com/software/tgpr/