Some tips: Choose one or two evocative pics, not 8 of the same thing. Mix up people with landscape, for variety. Insert movie clips occasionally, to spice it up.
Software to make this easy: Surprisingly difficult to make a simple animated slideshow, it turned out. I tried a few programs that were on my computer and finally got results from Photoshop Elements, which will export a nice slideshow movie to Premiere Elements for creation of the DVD itself. On the Mac, the settings and process was a little hidden and didn't offer the same control over the zoom/pan effect, but you can achieve the same results with iPhoto and iDVD. It seems that Picasa will do it (haven't tried). Some DVD authoring apps will, and any movie-making app, but you really want some tools built for slideshows to make it easier for yourself.
Disclaimer: I've definitely violated these rules too, so this was a good reminder to me, too.