Savevid.com is a tool which gives you the ability to download videos from streaming video sites. You can download videos from Youtube, Google Videos, Metacafe and more in FLV, AVI, MOV, MPG or WMV formats.

Some of the supported sites:

And many many more!!!