Actually, you should treat the issue of Success/Failure in a completely non-judgmental way. If the goal was achieved: Success. If it was not: Failure.
There is another question in Dramatica which is where you make the judgmental call: the Story Judgment. If the MC resolves their personal angst, then the judgment is Good. If the MC is left having to cope with personal issues, then the judgment is Bad. The degree of Success, Failure, Good, or Bad is completely up to you. Combining the two questions gives you four different kinds of endings: Success/Good = Triumph (Star Wars). Failure/Bad = Tragedy (Hamlet). Failure/Good = Personal Triumph (Rain Man). Success/Bad = Personal Tragedy (Silence of the Lambs).
As far as Rob Roy goes, my take on it is that the general concern (for EVERYONE in the story) is to protect one's honor (abstracted as the honor of the Scottish) and one's own to prevent destruction of the family line. This is true of the peasants (tracking down and killing cattle robbers) as well as gentry (both English and Scottish). More specifically, it is the concern for Rob Roy and his friends and family (Story Goal). If that is the story goal, then it is a Success / Good story. HOWEVER, Dramatica also discusses a story point call the Story Costs. In Rob Roy, the costs are very high. This offsets the "triumph" feel of the story by bringing the value of the goal down