I like a Yorkshire accent. It's familiar to me because my grandparents came from Yorkshire. A very broad Yorkshire accent is hard for me to understand though so it may be pleasant to the ear but not very helpful in understanding what they are saying.
Geordie-no way. Nice for them -- they can talk to each other and no one knows what they're saying.
The accent around Stoke-on-Trent is incomprehensible to me, whatever that accent is called.
The way they speak in the Cotswold area is fine -- I can understand my cousin there really well. But then, I can understand my Yorkshire relatives too.
I don't like Cockney, it sounds foolish and it has those expressions and words that are unintelligible to anyone but themselves.
As an American who married a Brit from Burnley, Lancs -- I can't understand a word they say when they get going. Maybe I'm once again referring to those who have a broad accent. I can understand my husband now (most of the time) and I adore his accent but there certainly are a LOT OF WORDS that are different in the two "languages" and cause some misunderstanding.
In the long run, I do appreciate different accents -- the only problem is when you NEED TO KNOW something and you can't understand the person's answer. I can understand some Brits better than I can understand some Southerners here in the USA!!