In fact; I have a laptop right now that hasn't received updates because there's a shared object that has been removed that `yay` depends on.
(this was from a long time ago).
I generally think that updates of the mainstream distro's like Debian will definitely *NOT* brick your system in almost any circumstance, and arch tends to be somewhat solid, but every once in a while something dire happens with arch which would make me not agree with the fact that updates are always seamless.