The advent of Flatpaks have really made Debian Stable into a serious contender for desktop Linux, and Debian 12 is a remarkably good release even by Debian’s standards. Bookworm has received a lot of praise since its release, and I think people (like myself) are starting to reconsider what a desktop Linux can look like.
It does take a little bit of extra setup to get more cutting-edge stuff for the applications you use most often, but after sourcing everything and stuffing all the individual updating mechanisms into an update script, you’ll get the best of both worlds - stable base and rolling user applications. If nothing else you should try Stable first before resorting to Sid - you may be inheriting Sid’s volatility without a proper usecase. If you don’t run Debian Stable or Debian Sid/Arch Linux, you’ll probably want to go somewhere in the middle like OpenSUSE Tumbleweed, which is cutting-edge with extensive testing baked-in.