How do the different Spanish accents sound?

I don't know the official names but in English there are

the different American accents - general, soft southern, hard southern, California, Boston, Brooklyn, Long Island, Chicago, Minnesota
British - all the hundreds they have - cockney, scouse, scottish, welsh, etc.
Irish
Australian

In the Spanish speaking world, is there a country that has the most accents (like the UK for English)?

Is there a more common accent such as the general accent that both US and Canadians mostly have?

What is the most harsh (IMO Scottish for English) and what is the most gentle (soft southern English for me)?

Is one considered more elegant (IMO Received Pronunciation) and one less intelligent (IMO hard southern)?

The only two Spanish accents where I can tell a difference is Spain Spanish because they sound like they are lisping.

Hi, I was super interested in the TaLK Korea program (they pay for housing, travel etc). I will be a Freshman in college this fall and I'm going to major in a language, I'm not sure which yet. Anyway, I can't do TaLK until I've completed 2 years of college because I'm not an ethnic Korean (I'm Dutch/Welsh) so I was thinking of applying for that later on. However I'm wondering if there are similar programs, because I love to travel and I plan to move out of America and become an English teacher elsewhere when I am done with college.

I'm crap at Spanish and Portuguese so south america/spain/mexico are sort of out of the question.

i've read some time ago that only 4.93 % of welsh people speak welsh, and i know it's the same in Ireland and Scottland with gaelic and in France with breton, provençal. i know they should also speak english and french because is the official language, but I think they(irish, scottish, welsh) should learn how to speak these languages fluently, after all....is part of their culture!

I ask this because in Spain we have other languages appart from Spanish(galician, catalan, basque) but they all(or at least, most of them)can speak, read, write them in Galiza, Catalunya and Basque Country.

thank you for the answers! it would be nice to have any answer from irish, scottish, welsh people.

sorry for the spelling, I don't know if I wrote it all propperly!