In general I find distros using old kernels annoying because Linus treats compatibility seriously and “don’t break use space” has been a mantra for many years. On desktops in particular, GPU driver improvements like https://www.phoronix.com/news/Linux-7.3-DRM make it super worthwhile.
As for exactly which distro, it matters less than you think. I use openSUSE Tumbleweed but plenty of my friends prefer Arch.
There is a balance: too outdated is bad, too eager for new versions is bad. The tradeoff that LTS tries to take is older, proven versions but with relevant security fixes quickly.
This doesn't seem to be popular with linux though. It's one thing I like about FreeBSD, everything is easy to keep very bleeding edge.
Maybe Debian 'testing'?, is that commonly run in prod?
> This doesn't seem to be popular with linux though.
Nobody ever got fired for buying IBM.
Nobody ever got fired for choosing Java.
Nobody ever got fired for choosing Debian.
It's a bandwagon effect. Though, it can also be a matter of common familiarity if you're not the only admin.
However, since I run a VPS host most of my customers run Debian or Ubuntu, due to both being more approachable than RPM-based distros.
I'm not a huge Ubuntu fan due to it being a very heavy downstream of Debian, versus Rocky which is 99.9% RHEL. I hold no grudge against Ubuntu, they made desktop Linux very approachable when Mandriva, Knoppix, et al. weren't.
But Canonical is too much of a downstream versus Red Hat, constantly losing standards wars. And unlike BSD (where I can understand) Canonical is a downstream by choice. It's like Sony who keeps losing standards wars to rivals.
Even in my homelab EVE-NG runs on Ubuntu.
for something more serious than a personal project, I'd go with Debian because of their vast free support windows and some incredible companies providing extended support
People are saying Debian. What are the tradeoffs? (other than faster patching on Debian of course)
Older packages, but that's one of the reasons I use it. On the stable branch you will only get security fixes and very rarely updates for critical bugs.
If you need to use newer packages the testing branch is surprisingly stable (it is the base for Ubuntu) but there are a lot of updates.
Well, I do use Arch on a lot of my VMs but still.