Being a Mac guy I can't speak to Windows configurations. FWIW, I help folks buy both Mac and Windows--what's best for their applications, wallet (nothing like a cheap Windows laptop if all you want to do is browse the web and use email) and experience.
You're correct that M.2 NVMe disks are quite fast. This can expose the speed of the slot being used, external chassis configuration and connection. So, a disk on the system bus/motherboard can have a more direct connection to the CPU than one in an external enclosure connected with USB-C or (the similar-yet different) Thunderbolt 3. Both might be PCIe but one might be x4 and the other x1. Or, the external enclosure's connector may need to go through separate interface chips before it reaches the system bus. So, lots of variables!
As for SSD speeds, you're loosing capacity for the speed. SSDs seem to max out at 2TB while good hard drives can be 14TB or more. But, you can use RAID 0 to stripe two or more SSDs together, giving you a larger "virtual" volume. Given video's voracious space appetite, having a larger drive can be good. (JBOD with spanning also gives you a larger "virtual" drive.) I don't have specific experience here but if you're dealing with slower interface technology then using RAID 0 could put the NVMes on different interfaces so one doesn't get swamped.
That said, in my limited experience, two things help: 1) putting your video on fast drives and 2) using proxies. So, if you're looking for the best editing experience I'd suggest creating smaller proxies and putting them on your fastest drive. The source video should hopefully be on a fast drive (for generating proxies and delivering). I'm personally less concerned about where my databases are stored.
BTW, you mention RAID 1 which is intended for backup/mirroring. It's always important to have backups, especially of irreplaceable files (aka, source video and edits). You can also use separate backup scripts or solutions. I've heard--but don't know for sure--that having a RAID 1 config can result in some performance degradation. I'm a bit leery of RAID 1 mirroring. If I do something bad and corrupt a file, etc., the corrupted file could be written to both mirrors! So, successfully mirroring failure! With backup scripts I can always go to the backup to recover from the corruption.
Finally, before investing too much, try creating proxies of different resolutions/sizes. See if you can achieve acceptable Resolve editing performance using proxies only. If not, start looking at SSDs and RAIDs.