I would advise you get Debian + GNOME and install all software via flatpack/flathub. This way you’ll have a very solid and stable system and all the latest software that can be installed, updated and removed without polluting your base system. The other option obviously is to with those hipster of a systems like pop, mint and x-ubuntu.

Now I’m gonna tell you what nobody talks about when moving to Linux:

1. The “what you go for it’s entirely your choice” mantra when it comes to DE is total BS. What happens is that you’ll find out while you can use any DE in fact GNOME will provide a better experience because most applications on Linux are design / depend on its components. Using KDE/XFCE is fun until you run into some GTK/libadwaita application and small issues start to pop here and there, windows that don’t pick on your theme or you just created a frankenstein of a system composed by KDE + a bunch of GTK components;
2. I hope you don’t require “professional” software such as MS Office, Adobe Apps, Autodesk, NI Circuit Design and whatnot. The alternatives wont cut it if you require serious collaboration and virtualization, emulation (wine) may work but won’t be nice. Going for Linux kinda adds the same pains of going macOS but 10x. Once you open the virtualization door your productivity suffers greatly, your CPU/RAM requirements are higher and suddenly you’ve to deal with issues in two operating systems instead of just one. And… let’s face it, nothing with GPU acceleration will ever run decently unless big companies start fixing things - GPU passthroughs and getting video back into the main system are a pain and add delays;
3. Proprietary/non-Linux apps provide good features, support and have tons of hours of dev time and continuous updates that the FOSS alternatives can’t just match.
4. Linux was the worst track ever of supporting old software, even worse than Apple;
5. Half of the success of Windows and macOS is the fact that they provide solid and stable APIs and development tools that “make it easy” to develop for those platforms and Linux is very bad at that. The major pieces of Linux are constantly and ever changing requiring large and frequent re-works of apps. There aren’t distribution “sponsored” IDEs (like Visual Studio or Xcode), userland API documentation, frameworks etc.;
6. The beautiful desktop you see online are bullshit with a very few exceptions. Most are just carefully designed screenshots but once you install the theme you’ll find out visual inconsistencies all over the place, missing icons and all kinds of crap that makes Microsoft look good;
7. Be ready to spend A LOT of time to make basic things work. Have coffee and alcohol (preferably strong) at your disposal all the time.

(Wine for all the greatness it delivers still sucks and it hurts because it’s true).