Honestly, I’ve never had an issue with a MacOS upgrade. I will caveat that statement noting that I typically do not apply the X.0 update, I usually wait for at least the X.0.1 or X.1 to be released.
I thought I had an issue updating to Monterey. I had a pair of 2019 16” Intel MBPs that were identical except one was silver and the other space gray. The silver one would not apply the update, it failed at various points but never completed. Turned out that was my one Apple hardware failure – a bad RAM module.