Absolutely, and Psalm 119:120 says this: My flesh trembles for fear of You, And I am afraid of Your judgments.
And, I personally believe the Apostle Paul when he says this (2 Corinthians 5:11): Knowing, therefore, the terror of the Lord, we persuade men...
BTW, I read "Sinners in the hands of an Angry God" when I was but a babe. It scared me pretty good, but I never hated it. Hmmmm!
I'll have to admit that the first time that I even heard the title I hated it, but that was before the Lord opened my eyes of understanding...