Indeed, dnf (and other tools as reliable) are impressive. Never had an issue running a "sudo dnf update" even on a desktop with a decent amount of packages.
Once i had to fix a conflict during a Fedora version update. Apart from that it has been rock solid.
Windows 2019 cumulative updates are not bad, but 2016 is cursed. Be ready to put aside at least 90 mins for older 2016 installs, and cross your fingers it doesn't fail.
"Major linux distros" are mostly running on the servers in the headless mode, with most of the updates never even bothering the end-users.
"Major Windows distro" has video, sound, peripheral, network drivers; user software which is not a part of the operating system updates, VisualC redistributables, .NET version and it runs on anything from $100 10 years old system which is not even officially supported[0] to the latest $$$$ laptops, which still has shitty drivers because anyone capable of writing a good driver is not working in Intel or Broadcom, or retired for 10 years already.
Comparing Linux and Windows update models is... quite a futile endeavour, they are different.
[0] but billg is still blamed for the BSODs despite that
Once i had to fix a conflict during a Fedora version update. Apart from that it has been rock solid.
Windows 2019 cumulative updates are not bad, but 2016 is cursed. Be ready to put aside at least 90 mins for older 2016 installs, and cross your fingers it doesn't fail.