Most of my clients want to incorporate a rotating-image web part on their intranet home pages, and most of them dislike the MOSS 2007 out-of-box This Week In Pictures web part because when you click the link for "View Slideshow," the slideshow opens to display the first picture in the image library, not the image the web part currently displays. Aside from developing your own web part or purchasing one from a third-party vendor, there is no way to make that slideshow link point to the currently-displayed picture (There is no view choice field on the web part, and changing the sort order of the "all items" view has no effect on the slideshow).
One of my clients recently designed a workaround to this issue. She asked me to put a workflow on her Picture of the Week image library which would move past pictures to a second picture library. This workflow is a simple one to build in SharePoint Designer; see screenshot below. When she adds a new picture, she changes a metadata field on the previous picture from "Active" to "Past." This change kicks off the workflow, which automatically copies the previous picture to the Past Pictures library and then deletes it from the current picture library. The result is that the "view slideshow" link always points to the picture that is displayed.
This way you can upload multiple photos that are associated with the main picture (for example, a series of pictures from a company outing), and they will be shown together in the slideshow. We put a "View Past Pictures" link under the web part so that employees have easy access to the archive of previous pictures.