I don't know about Sean Connery's (although it's very distinctive and not at all unpleasant), but I've somehow always found the Edinburgh accent one of the most pleasant regional accents on the ear. I think it may be the way it's so gentle and melodic.