That would also be my wish.
I live in Germany Electricity cost is quite high and i know i could use an only SSD pool but i have 4x4tb HDDs and 2xtb SSDs and don't plan to change that anytime soon.
I would i'm a noob and would love this exact feature.
User has 1 share !
All data from user is written on SSD and only once a day copied to hdds
The top things i access offen are also stored in SSDs and IF i need something else the hdds spin up. And the system Spins them up in the night does its things and then goes to sleep.