I can only think of 3 cases in as many years lol.
- KDE patch at beginning of the week made it so scrolling the start menu crashed the desktop, fixed in ~3 days
- LY changed the service to call it so I got booted into the TTY next time I started my PC
- There was a wifi card update which stopped my wifi from working, fixed with a power cycle.
Don't know where arch got its reputation of being held together by hopes and prayers, maybe it was more unstable in the past?