Cam Wizard detects motion and starts recording video and audio into a WMV movie. It is a shareware motion detection application that's easy-to-use and customizable.
Here are some screenshots to illustrate the features and user interface of this application: