Lightroom-like software for video (categorizing & organizing footage)
I think the keywords your looking for is "media asset management" or "video asset management". Apart from the numerous commercial softwares around, this list of open source alternatives might give you a good overview. 

http://www.opensourcedigitalassetmanagement.org