Agree, can never have too much storage.
In my early days, my workflow was Projects on 1TB M.2 (local), assets on a 2TB M.2 (local) and archived on 10TB HDD (local).
I soon grew out of that workflow as I captured at higher and higher resolutions (4K 60, 8K 30) in RAW and 10bit color — need more space and flexibility, my new workflow for storage:
2TB M.2 projects (local about 7000MB/sec)
70TB NAS for Assets and Networked Projects 10G (1250MB/sec)
70TB NAS to render server 20G (2500MB/sec)
I ran render testing against my NAS (network RAID 5 – 5 HDDs and 4 SSDs), 2TB internal NVME M.2 (local), and my 10TB HDD (local) … performance between my NAS and M.2 was within margin of error (almost identical). Performance to my HDD and the project rendered about 30% slower. Your mileage will vary somewhat based on CPU, Chipset, etc. but from my testing the CPU/GPU are still the bottlenecks in rendered output when running any I/O above 300 MB/sec.
Probably more than you wanted to know, but what you might gain from my results is that just about any M.2 or SSD will be sufficient.