Although I agree with what AussieJohn has said, I think that I can add my :twocents:
Errr... yes and no.
There are certain plug-ins and already-made scripts that will allow you to do whatever you want to do with a minimum knowledge of the language but you do need that minimum... or at least, you need to read the instructions. Most of the time, this involves applying the right class to the element that needs to be added to the lightshow but sometimes it also means some basic touches to the script itself (again, following the instructions)
No use of reinventing the wheel unless I look at the code and I see that's really terrible.
Having said this, if you're going to use JQuery, you can find similar scripts for JQuery so don't give it a second thought.
People are wrong.
First, as AussieJohn pointed out, DW is only a developing too, and WordPress is a content management system which has nothing to do with development. True, WP does provide lots of plugins to help you with your development, and it gives you a good starting point to build a site. But it is a content management system and its goal is... to manage content, not to create websites.
We will be still here. Automated stuff can only go this far. It will help loads to speed up your development and shorten the times for delivery. But you still need an expert to get it perfect