If you don't mind spending a bit of money ($30ish) Photodex ProShow works great for me. You just drag and drop photos and music (mp3 or wav) and add any effects you may want. Burns to a videoCD or DVD.

http://www.photodex.com/products/proshow/