I have taken the bus to Hartford, as well as the train to and from New Haven. Both are reliable. The bus from Hartford to South Station with be cheaper and faster.

The train route you proposed would work, but you are right in that it would be a long ride, and the changeover at New Haven could add some time.