It's not your fault because with nvidia gpu you have to add env variables to tell your pc that use nvidia prime, no matter what distro you use you have to configure env varibales, although I'll suggest you openSUSE-Tumbleweed and I was going to suggest you Fedora but you had problems so it's ok.
I think you should try dual booting or try Linux in a virtual box just to check that you can do your work on Linux and if you can't then you know the answer.
You can really download more ram if you use cloud storage as swap