Can't really go wrong with anything on the Southwest side of RI, or SECT near the border for that matter. Exeter and it's CT counterpart Voluntown get a little woodsy, but even they have their charms.

If I was moving to this area for any reason other than the reason I moved here, I would probably buy something Central Westerly/Pawcatuck. Ideally walking or at least short biking distance from downtown.