Does it make sense to use a compressed filesystem?

Question

File systems

The situation is this. There is a lot of text data coming in. Arrive in the form of zip archives. The processing program unpacks them and unloads them into the database. 20% of files get to a DB. The remaining 80% are old versions, which in theory can be deleted.

Here's what I thought. Maybe it makes sense to store files not in archives, but on a file system that supports compression? Then I would have end-to-end access to all files and it would be easier.

The average file size is 500kb.

What are the pros / cons of such a solution and which file system is better suited?