Is the motivation behind someone providing aid/comfort to others more important than the aid itself?

Yes, it is. If your intention is to reward the person for some value that you see in them, then your aid is noble. If you are simply giving it of some mistaken sense of duty, then the aid is immoral.

"Do you ask if it’s ever proper to help another man? No-if he claims it as his right or as a moral duty that you owe him. Yes-if such is your own desire based on your own selfish pleasure in the value of his person and his struggle. Suffering as such is not a value; only man’s fight against suffering is. If you choose to help a man who suffers, do it only on the ground of his virtues, of his right to recover, of his rational record, or of the fact that he suffers unjustly; then your action is still a trade, and his virtue is the payment for your help. But to help a man who has no virtues, to help him on the ground of his suffering as such, to accept his faults, his need, as a claim-is to accept the mortgage of a zero on your values. A man who has no virtues is a hater of existence who acts on the premise of death; to help him is to sanction his evil and to support his career of destruction. Be it only a penny you will not miss or a kindly smile he has not earned, a tribute to a zero is treason to life and to all those who struggle to maintain it. It is of such pennies and smiles that the desolation of your world was made."

- Ayn Rand -