Discovered Animoto a while back for creating quick, cool video for presentations, the web etc.
This is a really great tool. All you need to do is upload photos, or select them directly from your flickr account, select some music, or upload your own, and it does the rest.
The amazing bit is that this is a TV like production. None of those static images or simple Ken Burns effects, this produces something that would look the part on the TV!
Have a look at the below for an example.