It's really not a go yet. Mods can only fix the most superficial problems. They cannot fix the barely-implemented A-Life 2.0 besides doing some minor changes to spawn distances (which in turn creates new problems) or the quest bugs that start cropping up about halfway through the game because that's where any sort of polish stops. This week's patch should fix some of the progression bugs and softlocks, and hopefully retune the economy a bit (especially repair costs -- right now a -40% mod isn't even remotely enough) but A-Life is likely still months away from being functional and the same probably goes for any major performance fixes too. If you're really dying to play it, you should at least wait for the patch.
I don't think they're doing anything other than maybe some minor tweaks to the combat balance either, although that mostly can be fixed with (several) mods. I ended up with one mod that changes mutant hp, another that makes it so that humans die in 1-2 headshots or 3-5 center mass (vanilla is 1-3 headshot or like half a magazine to any other body part, which is just straight up retarded), and then a third that rebalances weapons to deal damage based on the ammo they use instead of arbitrary/magical numbers on the gun. Plus some extra stuff like toning down grenade spam a little, taking away their aimbot, and fixing stealth to actually be somewhat functional. I suspect I'll have to keep fiddling with it as I progress further into the map because what feels mostly 'fair and balanced' now might become trivial later on.
Also, the biggest problem with mods is that you need to keep a list of the .cfg files that each one modifies because two mods hitting the same file will just end up with the one with the most Z's at the beginning of its name overwriting whatever changes the other one(s) made. To fix the problem you have to unpack the mods, merge all the changes together, and then repack it into your own custom mod.
The game itself is just kind of weird too. I assume it was intentional on the part of the writers, but literally every single quest I've seen where you have a "good guy" option and an "asshole" option, the former gives little to no reward and the the latter gives unique guns, extra loot like weapon attachments, scanners, and artifacts that are otherwise inaccessible (at that point in the progression), extra money, etc. I've yet to see anything pay off later on from not being a dick or bite me in the ass for the opposite.