I just zip them too and have extra info in the parent folder name (date, location, camera, mount, filter, number and length of exposures, object, etc.). Saves 30-40% of space. Tiffs don't zip well.
I catalog and tag images (end result jpg files) in my preferred media managing software (JRiver Media Center).
After that, for me it's pretty easy to find any object I shot and where the data is located on my computer.
Also a very useful tool for me is Everything (very efficient search tool by voidtools.com).
870Gb (not counting star timelapses and random DSLR star shots) of astro data since beginning of 2019. And I shoot OSC.
RPI 4 B (4Gb) with SMate
Askar FRA400, TPO RC6, Nikon D5500 full spectrum (with IDAS D1 clip-in filter).
ZWO ASI120MM Mini on ZWO 30F4
ZWO ASI224MC-S on Orion 50 mm f/3.2
ZWO EAF x 2
It doesn't do the archiving part (I guess everyone just stores somewhere), but it does cataloging and tagging images for future search. I still have difficulty using it, but it is the only one of its kind that I can find (on Mac only)...
C9.25 f/10, HEQ5, MyFocuserPro2, OAG, ASI174MC guide, ASI533MC Pro