I have been running Debian Stable on my (gaming/coding/general use) desktop and on my work laptop for close to a decade now, and I have had very few problems, things just work. The last problem of "too old system libraries" nature I remember was maybe 5 years ago, when Steam client did not work because of too old glibc, but one Debian release later the problem was gone.

I don't think it's as bad as most people think it is, nowadays.

There are other issues with Debian. They will radically rearrange upstream software to follow their own standards (e.g. try using Tomcat on Debian sometime). This is bad enough when they apply it to regular software, and downright insane when they do the same thing for security-critical software. It predictably caused quite possibly the worst general-purpose OS bug in history (their SSL key generation one). They did not change their policy in response to that incident and see nothing wrong.

I wish Debian would release 20.04 LTS, 22.04 LTS and so on.

That is the big feature of Ubuntu for me. Can set in my calendar when it's time to migrate services to the next version.

Flatpak exists; Nix exists; Guix exists. All of them make it easy to have newer software without caring about your Debian package versions.