I think that it all boils down to the question: Do you want the game to be completely deterministic where you can carefully plan for each and every situation or do you want the game to throw at you a few nasty surprises (like a weapon breaking in the middle of a fight) which force you to rethink your whole strategy? While I am a strong advocate of the latter, I understand that some people don't like the element of randomness.
Deterministic. If it was possible I would remove the concept of rng from strategy games entirely. I hate rng with a passion when it comes to strategy games. It's fine in DnD because it is not set on rails so you can "fail forward" as it were. In single player games on rails, not fine at all.
