Hey, guys. I've developed a product that works really great on my sites called PhotoPost GMS - available from
www.photopost.com
I use this system on my paysite
http://www.fitnessphotos.com and on my free site
http://www.extremebikini.com/thegirls and it handles all my galleries. You can upload photos thru the interace, via a ZIP file or via FTP for builk uploads. When you process the images it creates all the thumbnails (imagemagick or GD supported), medium images and even adds watermarks.
I use it to rotate galleries in an out (by "turning off" one and "turning on" another. This way I can cycle content without having to rewrite html code).
All the pages are dynamic and it tracks views and allows for keyword searching.
Take a look - let me know if you have any questions. Its written in PHP and easily customizable.
Version 2.0 is out and sells for only $59!
There is also a Pro version which intergates with many popular BB forums like on my discussions sites
http://www.extremefitness.com and
http://www.viperalley.com