Traffic is nothing compared to NYC. No real public transportation, though, in the Southcoast part of MA.
Any idea of what traffic is like in/thru Providence? Looking at some nice places 15-20 miles south of Providence and was wondering if it would be doable traveling thru Providence twice a day or possibly hitting the bridges and head thru Newport.