I wouldn’t want to sit next to a spinner either, and have not for many years. But @nabsltd is right that almost any crappy ssd will work from a write endurance perspective. While QLC would ordinarily be recommended against, for your use case it would be fine (especially if you put zfs zil on a different disk).I'm not necessarily looking at all NVMe, but I am looking at all SSD. No way I am running 5 to 8 drives on the desk I work at.
D5-P4326 is right around the same price as consumer m.2 QLC drives on a $/tb basis. While you can certainly find cheaper drives in smaller capacities I’d bet you’ll spend 100% of the savings on cables.