I am no programmer either, mainly a technical-oriented user, and I made the switch to a linux-only desktop almost 20 years ago. I tried several distros but I keep coming back to ubuntu (in vanilla gnome mode), with it’s closeness to debian and huge library of apps, with it’s massive userbase you get a lot of online community support, and it’s really polished these days. For the last 5-6 years or so I’ve been using “LTS” releases, doing major updates every two years, I found that to be a very reasonable cadence and it gives you great environment stability. The only significant downside I found these days is ubuntu’s insistence in using their (proprietary?) snap desktop container app ecosystem, I personally much prefer flatpaks, and actually I use flatpaks extensively on my ubuntu desktop for SW that needs frequent updating (darktable, logseq, etc)
Well these days we have flatpak to solve the “not in the repo” (or ‘old version in the repo’) problem.