You can browse the list of supported mods here, but I do want to give a shoutout to “ Craftable Cats” by mm137 as something I definitely, one-hundred-percent want in my Fallout. So far, what I’ve seen is about what you might expect - a mix of silly, stupid, useful, and questionable stuff.
I’m trying to keep my expectations in check as far as what’s possible with modding for consoles. Xbox One players are getting them first, on May 31, while Bethesda says they’re “still on track for next month” for PlayStation 4. Mods are headed to the console versions of Fallout 4 soon, which is good, because after the way Far Harborturned out I think some of us could use the pick-me-up.