Debian stable isn’t that much more version locked than CentOS or RHEL. Debian also has the Testing tier, which is semi-rolling. Or you could use Unstable. Or if you’re brave, you could use Nightly.

Ubuntu, Mint, PopOS, and others with Debian as an upstream are not Debian. They build their own packages on their own schedules.

Fedora is not “consumer grade RedHat”. It’s the rolling release upstream of RHEL, much like Debian Testing is upstream of Debian Stable.

The main reason Linux got a bad reputation was the tribalism of people going off half-cocked talking about their personal preferences without actually working with the alternatives and starting this sort of holy war diatribe.