Mods on consoles mean no content containing copyrighted IP is gonna be featured, no NSFW content, nothing radically changing the structure of the game.
Thinking theres gonna be 75%-80% parity between the mods on PC and console is hilarious
I've got several hundreds of hours of time played in Skyrim and Fallout 4 on Xbox, PS4, and PC. I know how robust PC mods are and have used console mods on both PS4 and X1 extensively
Whole reason I got an xbox last gen was because Sony didn't want to allow them for Fallout 4 and when they finally did, they were severely nerfed. No external assets or anything that modifies scripts. Basically what you're thinking of console mods in your post
Xbox allows those things so you can get mods like Witcher 3 background music and Assassin's Creed armor in Skyrim. There's plenty of 3rd party stuff on there and all the major nexus mods and expansions (ie Sim Settlements for Fallout 4 and the Falskaar expansion from Skyrim) get ported over. Pretty much anything that doesn't use crazy script extenders is fair game. Some of the more blatant copyright stuff does get removed after a while, but if you have it installed on your system it's still usable until you delete it.
No nudity or sex mods but we can live with that
Still plenty of titty/ass mods if that's your thing tho
There's levels to this
