It depends on the kind of fear. The fear of going off my beeminder is good enough to motivate me to stay on them. YMMV.

It quite possibly would (vary). I have developed something of a "@#%@# you!" attitude to threats that are ongoing and try to reserve fear as an exception-oriented motivation device.