I have hundreds of files that have Zero size or very small kb size

This post may be of interest.

@OogieM also lost data with DevonThink.

I do not use it so I have nothing else to offer, other than I hope you can get your data back.