Looks like the post that I wrote back in January is becoming more popular lately:
Saw some examples here: http://snook.ca/technical/jquery-bg/
and here: http://www.alistapart.com/articles/sprites2
I hope that as ui programmers move forward with these new effects, there is an effort to keep these effects clean. I always like to avoid the carnival look whenever possible.