I don’t know its hours but the Hartford science center is good fun, especially with kids but plenty there for a nerdy adult. Earlier in the year I’d recommend Riverfront Recapture for some rowing, but they still have a lot of parkland along the Connecticut River open for visiting. And I might be biased but the CT River competes strongly for most beautiful river, especially in fall.