I love that part so much, I'm a complete convert. Considering replacing SATA SSDs with NVMe SSDs just to reduce the cable load inside my rig. Just wish PCIe cards with dual NVMe ports were more abundant.
On my Asus Z270i, the M.2 that's right there has a heatsink too.
The Southbridge/PCH on the motherboard is at heart a PCIe fan-out switch that is designed to offer bifurcation down to x2 and x1 ports, but on the flip side doesn't support aggregating lanes into ports wider than x4 (which is the width of the host connection to the CPU).
There are already plenty of low-end NVMe drives that use x2 connections instead of x4. If you put them into a PCIe port that's coming directly off the CPU, you'll have at least two lanes rendered unusable.
Intel has a SSD coming soon that is essentially two x2 drives on a single x4 M.2 card (one with 3D XPoint memory and one with QLC NAND flash memory). I'm expecting this to only be fully functional when attached to the PCH or another PCIe switch that supports bifurcation down to x2. When attached to a CPU PCIe port, I expect only one half of the drive to be accessible.
The bifurcation limitations of CPU PCIe ports may end up changing as PCIe 4.0 and 5.0 make their way to the market, and make SSDs with x1 and x2 connections more viable.
I also haven't seen those quad-M.2 boards listing support for the mainstream Ryzen (AM4) platform, only the Threadripper and Intel HEDT platforms. Have you gotten an AM4 Ryzen system to split its x16 slot into 4x4?