In general upgrading from SATA to NVME will produce better responsiveness in the system overall unless you happen to get a lemon.
Price parity with Gen3/4 though is about the same for either gen option at this point. I just picked up 4TB Gen4 drives for under $200 where just a couple of months ago or so they were 2-3X that. They're HMB based though w/o DRAM on the stick itself.
If you can find the capacity you're looking for in a Gen4 version for slightly more go for it since you'll likely reuse it in your next rebuild anyway and reap the speed upgrade at that point. The other option would be using a PCIE adapter and sticking it into the x16 slot and get the speed now. Then again you probably have a GPU in that slot currently.
For instance here are some speeds from my 2 sets of drives.
SN850 / 1TB
sudo hdparm -Tt --direct /dev/nvme0n1p2
/dev/nvme0n1p2:
Timing O_DIRECT cached reads: 4158 MB in 2.00 seconds = 2080.73 MB/sec
Timing O_DIRECT disk reads: 4912 MB in 3.00 seconds =
1636.12 MB/sec
Lexar NM790 / Raid 10
sudo hdparm -Tt --direct /dev/md0
/dev/md0:
Timing O_DIRECT cached reads: 8712 MB in 2.00 seconds = 4358.46 MB/sec
Timing O_DIRECT disk reads: 23372 MB in 3.00 seconds =
7790.25 MB/sec
Now, if I use different test methods, those will be higher in both instances since this is just a quick short test that doesn't show true performance max speeds nor does it test writes.
For instance my laptop also has an SN850 / SN770
While watching the Disk activity in task manager I can see the SN850 hit 7GB/5GB+ speeds while running CDM

While watching the Disk activity in task manager I can see the SN770 hit 3.6GB/ 3.4GB speeds while running CDM.... This is a Gen4
in a Gen3 slot
So, looking at these you see the boost in R's but the W's look about the same. DRAM vs none doesn't make a huge difference in the speeds they move data. Wen testing the SN850 / SN770 in my TB4 enclosure though I was a bit shocked that the lack of DRAM produced better speeds. So, there's plenty of variables to consider when selecting drives / gen / etc. I've considered swapping the 2 drives in the laptop just to see how much of a difference there might be but, it's a PITA and I'm feeling lazy about doing it since it involves cloning and copying data back and forth.