Sorry. 31-year Linux user, here.
‘Broken’ packages? Never seen it. I can’t even understand what you may be describing.
I strongly suspect this is one of those “stop hitting yourself” moments, but with some explanation I’d like to temper that conclusion. I admit I’m playing the odds: if the package system is messed up, likely you did a “hold my beer” stunt.
it is quite literally a link to howtogeek article about how to fix broken packages.
Yes, but if it’s a broken package it’s usually something wrong in the packaging done by the distribution or the user did something they shouldn’t be doing. I have never seen a package break without me doing something to break it.
Standard updates on RHEL can sometimes break yum / dnf due to updating python.
Again, that’s a packaging issue, as the maintainer did not rebuild yum/dnf for against the new python. Aside from rebuilding those packages manually, the user can’t fix that either.
deleted by creator
You never tried installing Wine?
oof not sure about that, partial upgrade can be a doozy