I absolutely love Irish accents, though not on a woman. And I think Aussie accents are sexy, given the right circumstances.
If you go too far north or south in the United States the accents get to be retarded. Bostonian/Brooklyn accents are horrible, as is the southern drawl. And then there are backwoods accents that are hilarious in every situation.