RealPlayer came with a "downloader" which automatically ran when a web video was being viewed on your browser, but with recent versions of OS X and / or browsers, it did not seem to function. In some cases, it downloads the wrong video when there are multiple on a web page, and in most of the cases the downlaod fails.
iSkySoft iTube Studio claims to get the job done as intended.