You can get fancy with RAID and multi-drive enclosures. And I do. And there are times when only an SSD will do, like the 16TB OWC Accelsior 4M2 PCIe SSD I use in my 2019 Mac Pro along with the 8TB OWC Thunderblade.
But sometimes a single huge hard drive fits the bill beautifully. The new Western Digital 18TB hard drive is the fastest hard drive I have ever tested, and its 18TB capacity is insanely huge for a single drive.