Sometimes I use the macOS alias function - create a folder on a topic/project and drag videos and other files to it as aliases. This is quite flexible as the one file can be in several alias folders (e.g. for different projects)..
For media videos I still use iTunes on an old iMac. It has multiple fields for cataloging videos (but admittedly I only tend to use genre and favourites - except for Store purchases). As above, I use iTunes Playlists to manage categories. I suppose similar features are available in the latest macOS but I will keep my system going for as long as possible 
BTW, for many years I have stored videos on external drive and set iTunes to not copy files to the local drive. iTunes happily makes these videos available via Homesharing.