I would like to have a word with your agent who out of all things to see in US would suggest Connecticut coast line. First of all, Connecticut doesn’t even have a proper coastline as it faces Long Island sound for most of its stretch. Secondly, Connecticut cities and towns are very poorly suited for exploring on foot with a possible exception of downtown New Haven. Thirdly, if you want to see proper New England, Boston and the surrounding towns and communities are way more exciting than anything you may find in Connecticut. If you want to see New England, choose Boston as your base and then plan your trips to various surrounding coastline communities. You will also find plenty of exciting night life in Boston neighborhoods.