My two favorites are from Microsoft and are for;
Moviemaking and slideshows.
Windows XP Movie Maker - Great for digital Non linear Edting of home movies. Adds animated titles and transitions.
MS Photo Story 3 - Great way to add movement to your slide shows. Up-down, side to side as well as zoom in and out. Excellent for very lage images to zoom in on details.