I never felt any discomfort at nails on a blackboard. Sometimes it sounds pretty good.
However, I absolutely hate the sound of metal forks or spoons scraping against teeth. Also the obnoxious, destructive sound that a spoon banging on plates makes. Like, it is disgusting. I almost want to cry when I hear the pounding and smashing of a shiny soup carrier on a beautiful ceramic food holder.