For downloading videos from sites like YouTube and Google Video I'm pretty satisfied with KeepVid, but if you spend a lot of time on those sites you might find VideoDownloader handy. It's an extension for Firefox that makes downloading videos from more than 60 (!) web sites a painless two-click operation. It's mostly just a front-end for the web service of the same name, but you needed more icons in your status bar, right?