Image preview in RTC Links
One answer
The maximum attachment size is 50 MB in the Advanced Properties.
It is possible and advisable to use an external attachment storage system if heavy usage of attachments is desired, otherwise they bloat the CCM database.
To my knowledge attachment preview only works for certain limited types. I am unsure if size has anything to do with it, other than slowing down the access. So I would suggest to not assume that attachments usually have a preview.