And last it calculate how often the file is read.
Please tell, how that is calculated the first time a file enters the system? The system can only count, and not initially anticipate, how often a file is read.
With the 4GB buffer and then spill-over, what will probably happen when one import 10GB of RAW pictures, is that 4 will end up on SSD and 6 on HDD.
Then you start working on them, and the system moves the files to the SSD again. Automatic, yes, but slower than if you were able to specify the SSD as target for all files from the start.
You then discard a quarter of the pictures, but the remaining 7.5GB are files you have been working heavily on for a few days. So Fusion decides to keep them on SSD for some time.
A customer from a few weeks back calls you, and ask you to re-visit some files you worked on a month ago. Those files are obviously on the HDD now. So you open them, and starts working on them. Unfortunately your SSD doesn't have enough room to have them moved over automatically, because the 7.5GB you just worked on seems much more "active" in the eyes of Fusion. Perhaps a day later, your old files is also moved to the SSD, after some different files have been moved to the HDD.
So now you have 10GB of space on the SSD taken up by pictures you're worked on the last couple of days, that you know you won't be revisiting in the near future.
Or, the alternative: Import the pictures to the SSD. Work on them. Move to HDD. If a customer calls, you decide if the specific request mandates a temporary move to SSD.
Fusion isn't magic. It can't tell "oh, gnasher just sat down in front of the computer, I better get those mp3s ready" or "oh, it's Concorde Rules, I know he'll want his RAW files ready. Oh, and of course I know he's going to work on the not 2 weeks old, not 4 weeks old, but the 3 weeks old RAW files today".