My two cents.
I have quite a few Nvidia GPUs I still use (2080,3080ti,3090) but recently purchased two AMD cards. I have a 5700xt and 7800xt.
I recently started using Universal Blue Linux as my daily driver on most of my systems. Bluefin for my desktop with Nvidia, Bazzite for my gaming PC with AMD.
They do both work however I have still had more issues with NVIDIA than AMD. For example, running games tends to be buggier but that is specifically an Nvidia driver issue. I'm guessing most hot fixes come out for the windows driver first. For instance, FF7 Rebirth does not render world geometry on Nvidia on Linux. I do not have this problem under AMD
I started purchasing the AMD cards because I was growing tired of waiting for Nvidia stability on Linux.
Is it much better than it was before , yes Do you use Nvidia CUDA apps or AI? Check, that works! Is it still as smooth and seamless as AMD, nope, you're still going to end up with regressions.
I think it's only a matter time before Nvidia finally figured this out as they heavily rely on Linux as a platform in their own work. But right now your best user experience overall is going to be on AMD hardware.
I built a steam gaming PC for my livingroom using Bazzite, a minisforum BD790i, and a Radeon 7800xt. I love it and there is NO going back for me at this point.
(P.S. Decky Gen plugin fixes a lot of weird issues on games that support DLSS by letting you slip in far 3.1 or XESS in it's place + frame gen. I've even been able to get ray tracing running decently with this method)