How about a system where by spending a point before the roll, you get a bonus (either a plus, or bonus dice in a dice pool, or you roll twice and take the better result)...AND by definition, what you do is awesome.
I.e., you can still fail, but not for any reason that's your fault. So if you're lining up a sniper shot and you spend a point, then a failure will mean something like the target stooped to pick up his hat, or someone else unexpectedly walked in front of him or something, not that you're a lousy shot.
Just a thought, combining a few different ideas about hero points and resolution.