My only experience in the last decade is Mint and lately Nobara (Fedora 37 plus tweaks for gaming). Mint was pretty rock solid. I rarely rebooted except for updates. Occasionally Cinnamon would lock up… because reasons? It was too rare to worry about. The only complaint was that the packages I used were pretty out of date. I switched only because the 5.15 kernel didn’t support my AMD RX6600 (or I should say there was an issue with power save where the display wouldn’t show back up even after reboot).
As long as it doesn’t cause massive instability I would probably prefer a rolling update. Upgrading Mint every few years was a bit intrusive.