Well it's funny you mention ttrpg, because most of these work through a strong interaction between all players, GM included. Thus, what matters is what is considered fun by everyone at the table, and if one person having a weighted dice somehow makes sense, the right table will allow it.

Anyway, this is secondary, the point is that the pros and con balance in this is not in the favour of arrowhead here, they "outlawed" about everything from the get go, through the questionable change of anti cheat. I definitely agree with your example of the collect mission that got cheated through, but they could have used inspiration from other titles, from lobby browser allowing mods or not, even excluding those with flagged mod from interacting in the global campaign. They could have reached the modders of the most endorsed mods, worked with them somehow. They could even have made the mod support official and integrated, thus having stronger overview of who plays with what, with strong filtering. I'm thinking of Deep Rock Galactic here for example.

I'm just saying than in a normal PvE, apart from the economic side, you can't really "cheat", as in you are not impacting others. Cooperative PvE games only have to handle how players are able to team up or not regarding their preferences (kind of like finding the tight table for a ttrpg), and there are many ways of doing so, that arrowhead has not yet shown interest towards