Sadly I have yet to find a use for it
- It shouldn't be used on SSDs
- It shouldn't be used on system files
- It shouldn't be used on compressed files (which is almost all of them)
- You have to manually select which files to apply it to
- It is highly inefficient and sadly causes a much bigger slowdown when it works poorly then the benefits it provides when it works well (in theory this should not happen)
So basically, if you have a folder containing plain text files and nothing else then it will benefit from the compression... except the benefit in such a case is totally meaningless because you are not hurting for speed or space with plain text files.
Any program, game, or OS folder that gets compressed does more harm the good, and any media folder is most likely containing mostly already compressed files which it harms. Even document folders are bad nowadays as modern document formats are compressed as well.
If microsoft had a tool that would automatically compress files on non SSD drives, test for read speed of compressed vs non compressed, and keep the faster one, then NTFS compression would have a use. But since no such tool exists then you might as well ignore the feature