Here's a good quote from John Calvin on what motivates us to refrain from sin. He acknowledges the right place of fear and knowledge of judgment, but speaking of the pious mind, he says:
Even if there were no hell, it would still shudder at offending him alone.