I am going to install an automatic rotating photo header slide show on both my blogs with jQuery. (At some point.)
To make them I used Jalbum, a free Java-based web photo slide-show app for PC and Mac to make those. I started with Flash slide show templates, but Flash is hateful. The jQuery versions don’t require a browser plug-in and “degrade gracefully” if the user’s Java is not enabled. I used DrMikey’s Lightbox2 for the album linked above.
13 April Update: Came across this article and thread about Including jQuery in WordPress The Right Way.