Hi! I’m from Connecticut but lived in the UK for a decade. Happy to answer any questions. Honestly, if you want to see non tourist American, Connecticut would be great. But you really need a car. If you want nightlife and to avoid Boston or New York then New Haven is your best bet.