Animoto is one of those hip web 2.0 sites that does one thing very well. It allows you to upload a series of your photos, add some text and either select a soundtrack or upload your own. The result is a powerpoint / slideshow on steriods.
There is a charge if you want longer videos or to be able to download a DVD quality version but have a play with the free version and see what it comes up with.
Heres one I prepared earlier: