I was row C in Edinburgh and the guy was very near me, must have been first or second row, over on the right hand side. Very embarrassing to be a Scot that night.
Depending on how it is spoken and by whom, I certainly think Scottish is one of the roughest-sounding accents of the English language, particularly Glaswegian. Funnily enough, Scottish can also be one of the friendliest-sounding accents. I lived in Largs on the west coast for about a year, so I know
Cockney makes a good second, but it is only ugly ...