The awesome-selfhosted list is ..well.. awesome, however it lacks a hardware category to collect links and information on cheap low power small devices to be used to host our personal data/services, both to avoid keeping beefier PCs up 24/7 and to better isolate their functions. It could for example include from tiny boards with the bare minimum necessary to host very light services (Single NIC Raspberry/Orange/Nano/…
That's a port multiplier and if that works or not depends more on the SATA controller and less on the operating system. Far from all SATA controllers support port multipliers. And even less support fast port multipliers (FIS), which is not much of an issue if your main target is size.