They still work but they are a source of potential problems. And it's entirely Nvidia's fault for their practices. Avoiding Nvidia is just avoiding associated problems.

People talk about how "Mac OS just works" and you literally haven't been able to use an Nvidia GPU with their OS for years even on desktop rigs like the Mac Pro.

Anecdotally, my main PC runs Linux Mint 21, has an Nvidia GTX 1080, and installing the proprietary driver for it took me all of 5 minutes in the GUI Driver Manager tool. The FOSS nouveau driver was pre-installed initially but the GUI tool handled disabling it and enabling the closed source driver, then prompted me to reboot.

Never had a problem with it since then, but I'm also not trying to live on the cutting edge with Wayland.

Most business systems are using Intel GPUs unless there's a specific need for workstations with Nvidia or AMD discrete graphics.

No, it's nvidia doesn't "just work", intentionally.