there are busses, but they're not great. bike commuting to hartford - ambitious and exciting! might be time for gears.
really, the new haven-to-hartford part of connecticut is not a wasteland. fairfield county is the suburban wasteland (stepford wives, anyone?) - but you don't have to go there. nobody's holding a gun to yer head. and in fact, if they were, still don't go.