As above, Movie Maker is cheap as free and very simple, however output options are limited, and it doesn't like working with large files. Vegas is excellent and would be my recommendation for a cheap Windows based editor.
Before they f*cked the interface, I'd have recommended iMovie if you're using a Mac. Now I'd go with Premiere elements for basic needs, and Final Cut Pro if you're after something a bit more involved (and expensive).