Fast Video Cataloger is a cheap prosumer cross-platform app that does exactly what you are looking for, but It's not exactly designed specifically for professional videography, so it probably doesn't handle raw formats for example. You can drag clips from your catalog into your editor though. Source: over 2 years ago

This conflicts with yewtube, which incidentally, you may be interested in. Source: over 1 year ago

If you're comfortable with a text based interface, there's also the yewtube program which runs from the terminal and is pretty neat. Source: over 1 year ago

I haven't tried these but they seem to do what you're looking for: Mps-youtube Ytfzf. Source: almost 2 years ago

For youtube there is this commandline tool. Though it seems this fork is not that active any more: https://github.com/mps-youtube/mps-youtube. Source: about 2 years ago

I'm using mps-yotube, https://github.com/mps-youtube/mps-youtube with cvlc and confused about controls, how to pause, how to skip, etc. Source: over 2 years ago