I wouldn't expect too much from mods honestly. The most popular mods historically for Bethesda games have been ones that improve visuals in any number of ways, and those are all but guaranteed to be out simply due to the fact that it would kill performance. That leaves small tweaks and scenarios that often take many months to years before anything really solid shows up. I'm expecting a very limited and middling offering on console.
Thanks for the input. I don't have any experience with mods on PC or Bethesda games, so I'm not sure what to expect. I suspect you are right, and that's probably the way things will turn out.