First, I am not trashing the library.
You've just annihilated the non-destructive processing feature. From now, all further interactions - edits, exports, sharing, printing - will be based on the lower quality preview. Not sure what you call that, but that's removing a major feature of the iPhoto Library, pretty much the entire point of the Library.
Supposedly, preview version of a file is smaller because of cropped area.
No it's not, though that will be a fraction if it. As Léonie explained, JPG is lossy, so more data has been thrown away. It happens every time you edit and save a JPG. Back to that non-destructive processing thing again.
Second, I am not advertising this tool, I just mention the way one can benefit from using it.
Yes, but there's a courtesy here: when you suggest a course of action that causes dataloss you should point that out.
You might be surprised, but I'm not questioning the usage of non-destructive app.
But you are... See above.
Regarding the missing files: during cleaning procedure they were also detected as original files without duplicates. I deleted them long time ago and I have no idea why they were still remaining in the library.
Because you're library was corrupted. Which is what we were working on fixing. Non-destructively.
y the way, pardon my ignorance, but why do you think this tool is dangerous to Mac? Does it do something with system files?
Search the forum for the many, many threads from folks who had had major issues after using the app. Remember, your Mac doesn't get "dirty", it doesn't need "cleaning".