There is a bus from Hartford to Boston that I used to rely on about once a month (or two). You should check the schedule as they have reduced the number of busses during covid and have not gone back, but it is still workable.

For access to trains though, New Haven or thereabout is the best place to be for going to Boston and New York.