- Edited
If you are a single indie developer or even a small house(~10 or less people) then of course you can make anything work, but then the question seem almost irrelevant. I was answering from the perspective of running a production house with multiple departments where the art pipeline would be a separate department. I honestly thought that was obvious from my comment, but fair enough, my bad. I should have been clear about that. As for some examples that come to mind:
https://openassetio.github.io/OpenAssetIO/
https://www.foundry.com/products/katana
Mind, Katana is specifically for look dev and lighting for vfx, but I linked it since it is non-the less relevant as the other link there is to a cross industry effort to create a standard API for Digital Asset Management(or DAM for short) platforms which cites it as the inspiration. Bigger studios currently tend to roll their own custom solutions.
Blender's asset manager is supposed to be developed with OAio in mind, btw. It's been a while since I last followed the development of that though, so I don't know if they've changed their minds on it since then.
Other cool things potentially worth keeping an eye on, maybe:
https://www.aswf.io/projects/