"These games just let you become the head of every guild and faction in the game without consequences, it's SO unrealistic!"

Look, if you want to play out your BORING CLEFT-CHIN HUMAN WARRIOR GIGA-CHAD power fantasy in Skyrim and become the head of every guild and faction on the same character, that's your business...but if you were role-playing a specific character of a specific build with a specific personality, would they realistically put in that much effort?
Probably not!
Why would they? That's a lot of work to put into entities that have NOTHING TO DO with your gameplay style or your character's interests.
Imagination, discernment and reason are key here.
Something I miss from early-to-mid Elder Scrolls games is that they had faction politics. In TES3: Morrowind, if you joined the Mage's Guild, the Dunmer Temple and House Telvanni HATED your guts! There were consequences to your faction choices.
Can we bring back actual consequences, Bethesda? PLEASE? OTHER than Survival Mode? 🙄