Photoshop with my custom templates for doing member galleries.
For promotional galleries linking directly to the big pic I use Photoshop droplets to make the various pic sizes needed and then reuse a template. (I always name everything the same and keep the paths the same)
For making thumbs of movies
ThumbsUp is great.