I only have it on PS4, and yes there are lots of mods in the workshop. There are obviously limitations.
Every few months I try installing various mods to make what I want out of it, darker nights, flashlight mod, weapon and armour changes for a more hard core experience, etc, and end up with 15 or so mods installed.
Start a new hardcore mode, get just about past diamond city, and the game invariably starts crashing.
No idea which one or ones are causing the issue, and in the end I get annoyed and go play something else.