I have used many digital asset management programs over the years, starting with, if I remember correctly, Canto Cumulus. In most cases, I invested many hours building useful image databases that became unusable due to the program being abandoned or not being supported on a platform that I needed to use.
The program I use and have used for several years is Photo Supreme by Idimager. It is provided both on Macs and PCs, is very capable in handling metadata, performs well with my 70,000 image database (even on my aged PC), has strong developer and user forum support. Importantly, it provides a mechanism by which you can move your images to a different DAM and retain the metadata that you have associated with each image. This can save many, many hours of work.
It is not free, but I find it very well-priced for its value to me. I highly recommend Photo Supreme.
David P