Last time I tried Linux was about 10 years ago. I installed multiple different combinations until I found one I liked (I forget which though). I was attending university at the time (chemistry) and had it dual booting so I could switch back to Windows as needed. I really tried, but everything on the Linux side was just so buggy or complicated.
I was using Open Office or something similar, mainly for spreadsheets, and I just kept needing to switch back to Windows so I could spend my time getting the actual work done, rather than trying to figure out how to make the computer work. It was so long ago that I don't remember the details, but I vaguely remember it repeatedly freezing up on me for relatively simple spreadsheet tasks.. the kind of stuff they teach in beginners or maaaaybe intermediate Excel tutorials with 10-50 rows of data.
Eventually, I gave up on trying to do any of my work in Linux and figured I'd come back to it when I had some free time. When I finally had some free time, I decided to wipe the current Linux install and try something else. I had gone through the installation process so many times before that I thought I remembered the steps. Well, I didn't, and I managed to delete something super critical and couldn't even boot to Windows anymore. After much trial and error, some kind internet stranger offered to help walk me through it.. the only problem was that they were only familiar with Arch (?), so that was the distro we were going to use to get me back up and running. We got it fixed so that my computer dual boots, but I have to supervise the boot process every time since the default boot is Arch, and I'm just not ready to deal with that.
I've casually looked a few times to see if I can figure out how to change the boot order, but I'm too scared I'll end up worse off, so I've just left well enough alone since then.
I have an Android phone and rooting it is always the first thing I do, so it hasn't scared me off tinkering altogether, but I hardly touch a PC outside of work anymore, so there's just no motivation to try again.
I started using Linux desktops at work around 5 or 6 years ago, and even since then, the experience has improved greatly.
I've been on various distros with KDE over the past couple of years, but from what I've seen in passing, Gnome "just works" really well with most distros that use it. KDE requires some tweaking occasionally, but since 5.27, it's been rock solid for me, and the KDE team seems really dedicated to making Plasma 6 stable and easy to use.
You might want to fire up a VM or throw Ubuntu on an old laptop and see how it feels. It really has gotten a lot better for the average user, and something like Mint, imo, is really easy to pick up and just use.
Personally, I really like customization, and I work as a DevOps engineer (formerly linux sysadmin), so I don't mind getting really deep into the OS if necessary. But I don't think you have to if you want to have a good experience.