Very interesting article! I do exactly the same thing with my own data and it definitely is quite the balancing act.
No matter how you look at it; spinning disks are massively cheaper than solid ones. Good spinning disks can outlast solid ones too, especially on writes.