Nvidia works fine on Linux, I used it for ~10 years in both rolling and stable distros (Ubuntu, Arch, and openSUSE Tumbleweed). AMD just works better because the driver is FOSS and included with the kernel. Specifically, this means:

• no upgrade failures - if the kernel and nvidia driver sees out of sync, it'll fail to boot to a GUI and you'll need to fix it without the GUI; only really an issue on rolling release distros, and then only a couple times/year
• better support for new rendering features - for a long time, Nvidia just didn't work with Wayland because they refused to implement the same interface as AMD; they have since backtracked, but AMD still probably works better with Wayland
• timely updates - AMD updates come with the new kernel, Nvidia comes when someone updates the package

If you already have Nvidia, don't feel obligated to replace your GPU, but the next time you're looking to upgrade, consider AMD.