What is the best reliable ssd for workstation operation

Micron 7450/9400
Kioxia CD7/8
Solidigm D7-something

You can get M.2 → U.2 adapter cables or get a PCIe card where you can plug in cables to connect to SFF-8639 for U.2/3.
Or PCIe carrier card where you can plug in the drives directly.

PCIe slots are rare on Intel Core, so you probably need to use M.2 slots for that.

That megathread deals with everything related and the troubles associated with it: https://forum.level1techs.com/t/a-neverending-story-pcie-3-0-4-0-5-0-bifurcation-adapters-switches-hbas-cables-nvme-backplanes-risers-extensions-the-good-the-bad-the-ugly/