Mod support gets weird on Console.
Bethesda as mentioned allows it, But unlike on PC everything goes through their approval process. For instance one of the most popular mods for Fall Out 4 for is CBBE, which allows for more character customization, body size, dimensions, curves etc.... it is available on console, but its censored, the PC version allows nudity the Console version does not.
Other mods are outright banned on console, either due to branding or licensing issues or the type of mod. For example, branded weapons, or real world cars. Or something the dev/platform considers inappropriate and this can take many forms.
This means all mods need to be reviewed, which means staff to review them, which means time and money, something most devs don't seem too interested in. Even Bethesda seems to be pushing everything towards the "Creation Club" which is monetized, seemingly to offset the cost of reviewing mods, the good news is the modders get part of the money on paid mods, but Bethesda also gets paid, and while some people don't mind paying for mods, if that trend continues we get dangerously close to mods becoming the new microtransactions.
Then the platform like Sony or Microsoft needs final approval, which may or may not come, Sony is very strict about content and becoming more so recently... Several games needed the base game to be slightly censored to get on the console, meaning, one or two missing scenes from the game that are present on PC and Xbox...
And that's before getting into the fact that while some of the mods "Work" on console they can be a bit broken,
Personally I'd like to see more mod support on console, without having to "Jail Break" the consoles themselves.... But there are several roadblocks so I understand why more Developers/Publishers don't implement it. Hell, I played CP2077 on PS5 at launch, and after eventually bought it on PC just to check out all the crazy mods I was seeing, So i fully understanding wanting to have them, And I get not everyone can just build a new PC to experience mods with all the settings turned up, SO yeah it would definitely be cool.... but It's not very likely unfortunately.