The console versions of Skyrim, minus Switch, have mod support. They are limited in scope because they don't allow for external resources to be used for the mods - maybe Xbox does, I don't know - but they still offer a bunch of QoL improvements, visual upgrades, quests, weapons, spells etc. Some well-known mods like the Unofficial Skyrim Special Edition Patch exist on console and some well-known mod authors like Elianora or Juliha also publish their mods on console. It's pretty great actually. They can make your game look and feel really good.

The mods I was referring to that were removed are Mysticism and Adamant by SimonMagus616 (at least their Reddit handle) that completely overhaul spells and perks in Skyrim. I understand their decision to remove them, but my playthrough feels a little less cool now as a result.