Snow Leopard was mainly framework overhauls, but they're still doing those, year after year, only piecewise. People praise Snow Leopard as a golden release, but early on it was very buggy and, for many, slow (I still remember). It only became great after refinement. Now Tahoe seems stable enough (not counting minor UI glitches) that even Ableton/Pro Tools/SPSS/AdobeCC and other frequent troublemakers work fine on release day, an unusual feat. The "downhill" narrative seems to be nothing but baseless nostalgia.
Everybody also forgets that Apple always did yearly macOS releases except for a short gap around the iPhone and iPad introductions. That's not new either.
Everybody just fell in love with 10.6.8.
It's no surprise that it had lots of bugs because it rewrote lots of components. But the power of storytelling (and remembering via most-upvoted Reddit comment) has turned it into the perfect release.