I haven't used it but it seems to have a good reception online. At $40 and with a free trial version, it looks like it's worth a shot. It looks like a simplified version of more complicated pro software that is designed for beginners and hobbyists.

From the website:

Auto Movie Creator removes all the obstacles to movie editing! Have fun and be creative: let the program take care of the technical parts.

With the built-in Assistant Director wizard, you don't need to spend any time learning to use the program—it advises you every step of the way as you make your masterpiece. Another big time saver is automated scene detection. Instead of carefully looking through all your video footage and splitting it into scenes to edit, just select Detect Scenes and let Auto Movie Creator do all that work for you.

Using special effects is a breeze. High-quality effects like dissolves, fades, and wipes are only a drag, drop, and click away! You can even adjust the light levels or rotate the picture to correct for problems while filming. Select one of the included professionally-designed templates to create beautiful Titles and Credits for your movie. Combine media from any source to create your movies. You can use video, audio, and image files, or capture audio and video directly from a digital camera or webcam. Auto Movie Creator can turn a collection of digital photos into a high-quality slide show with only a few clicks. Add background music, voice over narration, and professional slide transitions and you have an awesome movie slide show.

Auto Movie Creator's unmatched Export can create movies for any purpose. Create video files intended to play on your PC, or save your movie in formats specially designed for DVD authoring. You can also export the movie in special web-ready formats for streaming from your site. There are built-in settings for popular web services like YouTube® and Yahoo!® Video. The program can even automatically upload your movies to web servers. If you have an Apple iPod®, Microsoft Zune®, or RIM BlackBerry®, Auto Movie Creator will save movies in exactly the right format for your portable player. Many other devices are supported. Create video that can be played anywhere on almost any player! You can create your movie in standard or widescreen. High Definition (HD) formats are completely supported. There are no limits on what you can create—yet you don't need to be a video expert to use the simple Export Wizard. See the complete list of supported formats.

You can even send Video Email directly from Auto Movie Creator. Share your vacation video or your child's game-winning home run with your friends and relatives with only a few clicks. The movie will be saved in a specially-designed format that gives both high quality and small file sizes, and sent using your own mail software.

We've combined professional-level power with a very simple, one-window mouse-controlled interface, to make Auto Movie Creator the perfect choice for anyone from beginners to experienced hobbyists. Try it today!