I read this thread a few days ago and now I've looked at Rolf's video on using Cinelerra.
This is a great example of this editor but as Rolf says at the end of the show "It is a beast of an application".
If you want your photographs as a slide show and perhaps burn them to a DVD for playing on a TV then
For windows users - DVDslideshowGUI is where you go. Has more transitions, effects, than you will ever need.http://download.videohelp.com/tin2tin/
for linux: this also works using WINE.
Again for linux, a simple video editor which also has a slideshow function is ManDVD. Its really a front end for the command line dvd-slideshow utility and is the one I use the most.
Can be a bit picky regarding dependencies but I have it up and working on my Mepis machine. Some Ubuntu files herehttp://www.softpedia.com/reviews/linux/ManDVD-Review-51807.shtml
Its been a while since I last visited the jcornuz site, the java app he mentioned was terrible to use and 'Manslide' has terrible dependency problems with my setup.