If just for backup purpose, any 4tb sata from known brand is fine

Except Adata and Kingston and Taiwanese/cainis brand of course

My suggestion: Crucial BX500 or MX500 (depending budget), or 870 QVO if you want stick to samsung

unreliable nand sourcing. some of them mix the nand flash in different batches. is better to get from reputable brand that also produce nand themselves like samseng, crucial(micron) or wd/sandick/kioxia

ps: intel quit and sold to sk hynix, ongoing rebranding to solidigm, sk hynix no presence in malaysia market for now
WD negatively is actually because them somehow downgrade their spec in their successors eg SN750 SE and SA510 being downgrade of SN750 og and blue 3d, but you can consider their older model as long as still got stock

For such operation, won't notice difference even between SATA and Gen 3 NVME SSD. Program still need to processed by the CPU when loading from SSD, current CPU can't processes GBs of data in a second.
Noticeable difference is when copying data and game that use DirectStorage technology.

Skip to 10:18 for conclusion.