It depends. If you are willing to download proprietary drivers from nvidia, it literally just works. Though I'd probably suggest not getting on a rolling release distro, or any distro that is focused on mostly sticking with libre/foss solutions. Ubuntu works great with non free drivers, out of the box, so just use that. Kernel updates might be tricky on some distros, so sticking with more stable releases is preferable in my experience

(I have used AMD and NVIDIA cards, including a 4 GTX1070 cluster a few years back with mostly little issues on both. Also used GCN andRDNA1, and now I use nvidia on ubuntu for work and it just works.)