(AFAIK that's the only thing "unstable" means: no guarantee any given package will stay there)
I stopped running sid not because of any instability or unreliability in the included programs themselves but because unstable required more active administration: apart from temporarily broken dependencies or upgrade paths, it made sense to stay informed on potential breaking changes. Stable(r) releases or distros rarely require almost any active care nowadays apart from installing security updates.
Again, my experience with sid was years and years ago but I don't suppose its fundamental nature as the active development branch has changed.