This all feels either out of date, or just incorrect.
You can use consumer cards for this. Both Nvidia and AMD consumer cards. Nvidia drivers work fine now, and don't require any workarounds (they previously "blocked" VM's with their driver, but was trivial to workaround). AMD have a few hardware quirks, but that can typically be worked around too. Though you're best going with Nvidia as it's more straightforward.
It also seems that a lot of virtualisation software supports it (libvirt/qemu, vmware esxi, proxmox, xen, probably a few others). It's typically also, set and forget. Once it's configured, you're good to go. There's not much of "keeping it working properly in the long haul". I've had my setup for about 4 years or so now. Even through software and hardware changes.
"The workaround" is to add few lines in VM's XML, which are available in pretty much every VFIO / GPU passthrough guide (in "code 43" sections). Like these ones:
And you don't have to do it for the most of AMD cards and the newest NVIDIA cards.
Unfortunately that's not beginner-friendly, I know, but that's the problem of VFIO in general - you can't really do it without being comfortable with terminal, editing configuration files etc. It would be cool to make it automatic somehow, but that would require making some tool(s) for all the preparatiary work (assigning vfio-pci driver, building united) and adding features to virt-manager (to be able to all the stuff graphically, without modifying XML).
But anyway, in your original comment you said that passthrough is not possible with consumer GPUs, which is simply not true. It's possible with pretty much every consumer card.
You can use consumer cards for this. Both Nvidia and AMD consumer cards. Nvidia drivers work fine now, and don't require any workarounds (they previously "blocked" VM's with their driver, but was trivial to workaround). AMD have a few hardware quirks, but that can typically be worked around too. Though you're best going with Nvidia as it's more straightforward.
It also seems that a lot of virtualisation software supports it (libvirt/qemu, vmware esxi, proxmox, xen, probably a few others). It's typically also, set and forget. Once it's configured, you're good to go. There's not much of "keeping it working properly in the long haul". I've had my setup for about 4 years or so now. Even through software and hardware changes.