jQuery can be useful as any other javascript frameworks, how ever the major point of jQuery is huge amount of contributors and plugins made based on it.
If you are looking for already build plugins have a look here ajaxrain.com there is about 500 of them.
solved Looking for Inspiration: How can jQuery be truly useful? [closed]