My plan for Audio use, yet to be tested as my Mac Studio is still on its way:
2 x 1TB SATA SSDs in USB3 enclosures serving Virtual Instrument Sample Data
1 x 1TB NVMe PCIe SSD in OWC Express TB enclosure for Project Data
3 x 8TB Seagate External USB3 HDs for Time Machine, Project Daily Direct Backup and Project Archive
Everything, including the Mac Studio, goes in a machine closet, so noise is not an issue. Hoping the External USB3 cases will allow the SATA SSDs to perform properly. I will have 2TB internal storage available and will be able to use that for audio-related data as necessary.