The cumulus project provides some very nice eye candy for your tag clouds. The cumulus project is what we are currently using on CollectiveColors.
The README.txt of the cumulus project does not, however, do a very good job of explaining what is required to install it and get it running.
12 steps to getting cumulus running in Drupal
