Not at all. It can also come from things like the pernicious "I know what you want better than you do" belief, which is sadly very common amongst DMs today (see: most defenses of illusionism), or from realizing that blatant actions are bad without realizing that covert ones are also bad.
Intentionally subverting someone's goal would fall under conscious malice for me. Sure, light on the malice, but still. And if you're taking steps to hide it, that's explicitly being conscious about it. This might just be a semantic difference between us. Also, I said that unconscious behavior on both sides absolutely can lead to instances of this, so the mere existence of this sort of problem doesn't imply anything about anyone's thought process.
How do you square this, then, with Max's multiple citations recommending the DM say yes, consider player intent, etc.?
Because, to my eyes, the DM did say yes. The player proposed using Rustic Hospitality. In response, the common folk opened up a place of rest and safety, and as far as we have been told, they did not betray the party. We don't know how the guards found them. It could have been simple detective work on the part of the guards, entirely unrelated to the townspeople. That fulfills every bit of text in the ability. If player intent was to avoid a fight with the guards, then finding a full night away from them is considering that, and granting it. They did successfully avoid it, for eight hours, which allowed them to recover to 100% strength, or at least very close to it. To avoid the fight happening forever, they would either have needed to lose the guards, or given them reason to stop the hunt, neither of which is
inherent to what RH provides them, in my eyes. Could I see a game where the players hid so well that the guards moved on to search completely elsewhere? Absolutely! That's where I'm saying different DMs could very reasonably have run this scene differently. But I also think what did happen here is also reasonable. I think it's reasonable for the DM to think about the situation at hand and go "Do I think the guards would lose their trail, based on RH alone? Eh, no, I don't see it. But can they hide for long enough to get a full rest? Absolutely."
Also, Say Yes, And is great general advice, great go-to advice but there are absolutely times that warrant other approaches, like Yes, But, and No, But.
Now, in the context of setting the watch, as mentioned before, that's where I can totally see the DM potentially not considering player intent. But again, I don't know why, and I don't know the layout of everything. Perhaps they had good reason to think the watch would not see this coming, based on the layout of the barn, etc., etc.. Perhaps not. More importantly though, I don't see malice, denial, or undercutting in the RH result.
Which all just reads to me as "never get upset about individual instances," and thus directly leads to never being allowed to be upset at all, because patterns only form from individual instances. Breaches of trust are a reason to stop trusting; it takes one unwise choice to undo years of trust.
With all due respect, that's absolutely not what I'm saying. First, you absolutely can get upset with a pattern of behavior without reacting to the individual instances on their own. Second, you can be alert for further problems while still extending grace on initial ones. Finally, while an egregious enough single choice can destroy trust, I don't disagree, I would also say that years of trust, to use your words, should be able to withstand some weathering, especially if it does end up being inadvertent.
But also, I do personally try not to get upset about individual instances, because I really try to use Hanlon's Razor in most cases, especially in the context of someone who I'm on good enough terms with to play a game like this, and I don't think that's a terrible attitude to have. It makes a lot of sense to me.