Maybe once gigabit internet service becomes more widely available, but even for something like a consumer NAS you’re probably bottlenecked by something else no?
Also, the main competition is WiFi which is significantly slower than 1GbE in most cases.
Also SSD are not 100 EUR / TB. A 4 TB SSD is like 300 EUR.
If you are talking about only two drives than no. Multiple drives can give you more throughput, but at that point it is RAID-10.
People who notice mine in the corner mostly don't even know what it is.
The simple spinning hard-drive was already faster than gigabit ethernet, and the NAS access speed was 90-95% of ethernet. So I am prerty sure that NAS is the bottleneck here. And this is on a WD-red 5400RPM harddrive, nothing special.