The last time I used arch, I ran an update and it broke my bootloader, meaning the next time I restarted it wouldn't boot at all.
Sure I could make a recovery USB and fix it, but at that point I was away from home, and just really needed to do the totally crazy thing of "using my computer to actually do work".
(To be clear, I didn't and I'm not recommending going back to Windows, just a more sane Linux)
Yet, when you go online to refresh your memory on how to update your Linux installation, too many of the guides still say STEP 1: Back everything up because you may not be able to boot after you do this!
But the usual way to install Linux nowadays is from a live boot, so you automatically have a recovery drive anyway. It's not hard to set up regular restore points with Timeshift or similar, either.
That said, I haven't had problems like what you describe in nearly 4 years.
Updates generally just work, on the balance of my experience and other available evidence. It's still unwise to schedule them at a time where a failure would be more disruptive than baseline, and it's still best practice to be prepared for a failure and not have to figure things out on the fly.