Dont know about that advice.
There is sata drives on the market that have no dram, and on planar TLC as a bonus. Its wrong to mark all SATA as clones of each other, as if its some kind of super slow tech that anyone can max out.
Also to point out random i/o isnt anywhere near saturation point on SATA and has much room for improvement.
Also I would avoid QLC based drives, dram or not.
Meanwhile the performance boost of NVME, isnt of any practical benefit to the vast majority of consumers, so unless its exactly the same price as a SATA drive or maybe even cheaper its wasted money in my view in this current time. You also have the issue that if its m.2 based its a pain to install or deinstall and might not be compatible with all your kit so have less flexibility how the drive is used etc.
Micron have just released a MLC based SATA drive, which at first glance would seem a decent buy as its 3d MLC nand, for much cheaper than a samsung pro drive. But apparently its built off reject first gen 3d nand that micron previously didnt use because it wasnt good enough, so it probably isnt as performant or durable as typical MLC nand. One thing we forget is nand can vary heavily in quality, MLC vs TLC vs QLC is not enough to classify the quality of nand, and the fact that Micron have felt the need to add a SLC cache to this MLC drive speaks volumes, as typically MLC native performance should easily be fast enough.