The last small app I wrote in Rails, http://glunote.com, I switched from the standard Prototype/Scriptaculous libraries to JQuery, just to give it a spin. Took about 5 minutes to install the JQuery plugin (JRails) and tweek a few things to get it up and running. Man, was I impressed. Not that glunote does anything super tricky AJAX wise, but I still found JQuery so much easier to use than prototype.
It's got a really shallow learning curve, it integrates well with existing Rails RJS and helper functions (thanks to jRails), has a ton of plugins and is pretty lightweight for a JS library. I'll be using it for all future projects.