You're thinking about this from a technical perspective. The content, and therefore structure and logical chunking of the metadata is far more consequential than the number of images. I've seen people in academic environments pour tens of thousands of post-doc-hours into cataloging a few thousand images:

https://nuremberg.law.harvard.edu/