When I went to primary school we had a priest who used to visit who was the typical old fashioned Irish catholic priest, so he used to try and scare the living crap out of kids everyday for not praying, or not going to mass etc. I can remember one day he made a girl cry because she skipped mass on Sunday to compete in a horse riding competition!
But at the same time my mother was a teacher in the school and quite a dedicated Catholic too and she used to always reassure us to not pay too much attention to the Fathers threats because we were all good people etc.
Fortunately that priest left before I finished primary school and his successor was a much more accepting man who had no issues with me being an atheist and was more than willing to respect my decision. He never intimidated anyone into believing in hell or sins and all that!
So I guess I got lucky here in that I kinda came into education in Ireland as the old fashioned Catholic ways were on the way out (theyre still far too much of influence however! but thats another story).
I never really experienced outside of education either. Catholicism in Ireland tends to stay away from the 'fire and brimstone' imagery and basis itself more on moral/ethical teaching.
The one scary thing I do remember as a child though is confession, that was the one time when you got the whole 'you're going to hell' treatment.
When I was ten, my mother decided near bedtime to talk to my brother and I about Hell. It was a devastating experience: she described it in all its horrifying detail, complete with fire and torture and a complete life without God. And she said it with as calm a voice as she could muster, because she was clearly terrified of discussing it, despite her interest in telling us something she thought was something good for our spiritual health.
The worst of it was while I was crying in horror, I asked her, "Isn't there any way to escape?" She said, "No." I cried myself to sleep that night.