Generally something to avoid unless you’re certain that you need it. It brings complexity, points of failure, and isn’t an ‘insert ssd to make slow hdds go fast!’ that most folks initially assume.
Everything you listed should work fine - considerations for the future:
Consider getting an LSI HBA so you can have your HDDs run on that & save the sata slots on the motherboard for a sata ssd for boot. This’ll let you use the two nvme slots on the motherboard for a mirrored pool for your apps & vms.
Just make sure you’re getting an HBA, not a port multiplier or raid card to avoid risks of further headaches.