I do this same thing. I dump the RAW files (enormous, thanks Sony) to laptop NVMe storage, process them, upload processed images online, and then back everything up to the NAS over Wifi in the background at a rate I don't care about. If I wanted to reprocess files from the NAS, I'd just copy them back locally in the same way.
The real speed limiter, the room for marginal gain in this workflow is generally the GPU capacity (and to a lesser degree CPU) to process the images, especially with all the AI NR stuff etc. If I wanted meaningful improvement, that is where I'd spend the money, and where the vast vast majority of photo people would spend the money. Beyond that the workflow improvement gains are largely in user interface (better monitor, keyboard/tablet etc.) Any modern PC's PCIE 4x4 m.2 drives are going to be orders of magnitude faster than networked storage, to where they simply aren't a factor in the total workflow. Flash storage capacity increases faster than RAW file size and I'd expect it to continue to do so; if I really thought the laptop NVME drive was going to die in the few hours the files were local, I could 1) cheaply add another M.2 drive for RAID1 2) just not delete the files from the camera cards until I was done. Online file upload speed is completely bottlenecked by the host.
Local transfer speed is simply not an issue. For the people that are shooting terabytes of images a day (or doing uncompressed video) they go to a flash-based DAS setup, which is worlds cheaper and easier than a 25gB network. Even if they use a NAS beefy enough to use in this manner, they'd be better off with a point-to-point link, since there's no third component in this workflow that can use this speed to justify a switched network.
Your use case example is working backwards, you built apparently a 25gB network and a NAS that would saturate a lesser connection, then tried to find uses for it. I am trying to convey that for certainly the photo normie and even out to the computer-nerdy semipro, if you didn't already have this hardware, this use case would make zero sense. You've spent 800+ dollars (and I'm sure far more on the NAS itself) and added a 24/7 30w+ power vampire and gained essentially zero meaningful workflow improvement. Most people would see that far better spent towards a better GPU or a new lens.