This might be a really great case for Rocky Linux though, as it also gets 10 years support.

That happens to be my plan. I just started rolling out a few but I will have to bulldoze some servers because CloudStack doesn't work in it yet. That means it's upgrade-disco for my 9s in 5 years.

Since 2002 I've been doing yum-cron for updates, but just at the side gig with up to 50 boxes. It used to be absolutely rock solid before systemd wrecked it, but it's still pretty reliable.