If you do not want your distro to force changes down your throat like Microsoft, maybe avoid Ubuntu.
“Stability” on Linux means two things. “Stable” distros like Debian or RHEL change their software infrequently. This is indeed stable. However, you will likely be unhappy with the old software and want to install newer stuff. Many of the ways this is done will cause actual instability (bugs and crashes). Also, old software may be missing features or hardware support. If you are a gamer for example, this could be a big deal—especially if you use NVIDIA.
Things are a bit better than they used to be with tech like Distrobox and Flatpak.
The frequently updated distros can actually be “more stable” for the same reasons as above. However, every once in a while some package is going to have a bug that may hit you before it is found. Arch or EOS are examples of such distros. They have massive software repositories that probably contain everything you will ever need. If you use one of these, check out the AUR (user contributed software repo).
Distros that fall in the middle, like Mint or Fedora, are what I would recommend for a new user. Compared to Windows, you will find them very tinker friendly and tweakable. Fedora is more Wayland ready (see below).
HDR is very, very new and is part of a change in core graphics tech from something called X11 to something called Wayland. From this point forward, Wayland is the better bet but, today, the quality of your experience is going to be very dependent of the “age of your software” issue above. For NVIDIA on Wayland, you want very up-to-date versions.
KDE Plasma is the most mature Wayland environment today, in my assessment. Others are coming along quickly. That does not yet help you now though.
Photoshop is going to be a problem for you. The most often recommended replacement for PS is GIMP. Unfortunately, GIMP has been on the verge of a major update for years. GIMP 3 has not shipped yet and most distros ship a far older version (2.10). Version 3 is a massive upgrade. However, you may still find it an unsatisfactory PS replacement. Some people use Photopea online.
Gaming on Linux works really well now. However, multi-player anti-cheat systems are Windows kernel only and so these games are going to be a problem. So, your experience will depend on what you play.
The other stuff on your list will work well. Linux of course has a lot more to offer, especially if you are a dev.
Good luck!
Honestly a lot of it is just momentum and familiarity although I also think US vs Europe is a factor. Linux was popular in North America first and Red Hat was one of the most successful distros early on. The fact that SUSE uses the Red Hat package manager reflects this. Fedora is backed by Red Hat, the de facto standard Enterprise Linux.
Both have their fans though and trying to argue that one is better than the other would be a war of preferences. Many people believe that Tumbleweed is the best rolling distro.