Well, my pick would be iPhoto on the macintosh...very professionally looking transitions with 'ken burns' effect too...and you can add music and control timing for each photo. Too bad its a mac-only product.
is there anywhere i can see some good presentation (example output) by these software? in the meanwhile will try to see if i can use photostory,
yah, i'm looking for those special burning, old film, more texture kind of transition effects that is not found in most of the above recommendation, including profoto, feeling a bit disappointed so far.