I've already installed Arch on a spare laptop to assess the difficulty of switching over. So far I'm very impressed!
arch-install made the setup pretty easy, and KDE Plasma feels very natural for someone migrating from Windows. Flatpaks make installing/updating apps a breeze, and there's way more apps available than I expected, including commercial ones like Spotify.
Most of the "muscle memory" habits translate across too, for example pressing Meta and typing "notepad" shows KWrite in the start menu. That was a nice surprise.
I can already tell it's going to be viable for 90% of my needs, and the fact that there's good free software to do everything from video editing to office tasks is really amazing. Linux desktop has come a LONG way.