The main issue with using Storage Spaces to "tier" your data and automatically do anything with it, is that Storage Spaces does not do that.
Yes, you can put SSDs and HDDs together in Storage Spaces, but in order to "tier", you have to essentially run a scheduled script to move specific files up into the SSD "tier."
This is fine for write once, read many, assuming you can wait till the script runs to promote the files, but if you are doing constant write/read operations, you have zero control of where those new writes land. There is no write caching and then reading from that cache (currently, that I'm aware of) in Storage Spaces Direct.
Example: https://richardjgreen.net/pin-a-file-or-vhd-to-a-storage-space-tier/
I fought with this a lot, hoping to use all my leftover Fusion-io hardware with Storage Spaces to make a killer home NAS, but it performed worse than my FreeNAS VM, so I finally just settled on a large FreeNAS build instead and re-purposed the Fusion-io gear for hypervisor datastores.
-- Dave