See, they do, if they are consistent and in line with the intended play/narrative experience. Of course, in practise, most RPG rules are utter trash, and the added minutia just detracts from the experience.
I disagree. What you mean is that if the table has agreed to limit the play/narrative experience, either through agreed table buy-in or through the table agreeing to limit it due to the adoption of a limited play experience provided by those rules, then that consistency happens.
But that's not a function of the rules qua rules. That's a function of the a priori limiting.
Put another way- running an AP is not a railroad if the table agrees to run the AP. Blades in the Dark is a great match of ruleset to fiction, but that's because everyone has already agreed to run a heist game in Duskvol.