When Americans talk about an "exotic location", they usually mean somwhere that's far away and hard to get to, but also really nice and expensive. Places that are thought of as "exotic locations" are:

beautiful islands

large cities in Europe, Asia, or South America

Places that are residential like small towns are not usually called "exotic".