Rolling release: openSUSE Tumbleweed Semi-annual release: Fedora KDE Spin LTS: Kubuntu (3 years), Debian (5 years), AlmaLinux (10 years)
I personally think semi-annual is where it’s at. You get packages that are mostly up-to-date (and with Flatpak user-facing software is up-to-date anyway), and you don’t have to fear that something will break/be incompatible with every small update.