I use Flip Album Pro 5. They also have a users forum that has been very helpful to learn to use the program and to get ideas on business applications.
www.flipalbum.com www.flipforum.com
I've used it for proof albums and final albums. It will also do a slide show. It has a lot of features. There are security features where you can prevent someone from copying the CD.
I allow my wedding customers full access to the CD. They can save the images for emailing and printing though I discourage that because the quality on screen is great but the files used are small and don't print well. I usually give them another CD with hi-res files on them.
Another nice feature is CD expiration. I use this for proofing. You can set the CD to become non-functioning after a set number of plays or set an expiration date. I usually give a proff CD that expires after 30 days.
I've seen work done on 3D Album which I believe gives you more control over using music. It also allows greater use of video.
What I like about Flip Album is the 3d page turning effects. The application is burned to the CD so your customer does not need any additional software. Put the CD into a drive and it autoplays (Windows 98 or later). I have not used it for a DVD.
I recently bought Adobe Premiere Elements (video editor). I haven't had much of a chance to play with it. I plan on using it to create music slide shows on VHS and DVD.