Thanks mr. fattipants2016. I turned of that settings and the balancer stopped once it had transferred the data from drives marked SSD into drives marked Archive in the pre-set order. However, once complete, it stopped. It did not "Move the existing files into the predefined order on the archive disk" at all.
I've since put the "SSD Optimizer" at "Leave the files as they are" then re-enabled "Ordered File Placement" and, fingers crossed, I'm experiencing expected behavior.
Files are now being preferably written to drives marked SSD, once the balancer runs it empties the SSD into the predefined order. Additionally it reorders files into predefined order on the balancer passes.