Gary, in case you're still looking for ideas, like Dave, I have done an artists/photography site in the past.
The link features a purely example site with the aim of attracting artists/photographers to sell their work online - (it hasn't worked yet, which may be telling) !!
this one features image galleries with a lookup recordset within the repeat region, in order to show (potentially) different size options and prices available for each image, and a lightbox popup.
maybe it will give you some ideas, even if only where you dont want to go.