As in the original article you linked:
The question here is this: if you’re not segregating the workload at the physical resource level, is there any need to segregate the workloads at the logical level? For example, if tempdb and my user databases are in a single pool of disk on the array, should I bother having them on multiple LUNs (Logical Disks) on the host?
For a high-performance SQL Server, you need separate physical resources. For safety, you need multiple instances. RAID 10 is usually recommended. For local storage on a physical server, use RAID arrays for anything but pet projects.
Bigger systems will use SAN systems, larger budgets, and usually a SAN administrator who can tune thing to your workload.
As a DBA, I would not use Storage Spaces for a SQL Server. That may change later as the technology matures.