Years ago major upgrades and to lesser degree even minor upgrades made me to give up trying to keep installation running. I don’t even remember if it was Red Hat or Debian.
Eventually I realized, that I like running newest version of Desktop and I ran into cases of getting frustrated with lack of newer versions, which had fixes for issues I ran into. Then I realized that best wiki was not a snapshot distribution.
In the end I tried rolling distribution and remain happy for years.
Debian or derived distribution is easiest to get google help for and it is the simplest choice for me, when running on the cloud.
Although, Alpine is pushing through containers quite forcefully.