Have you looked at any MAMs?

Most will combine on-premise and multiple cloud storages and then proxy a low res for previewing, with custom metadata modeling to find and retrieve everything.

Sounds like what you need.