Hartford: The Bulkeley Bridge, although I would nominate the Bushnell Arch if the Park River were not buried underground. If you want to get out in the sticks, I'll include the Cornwall Covered Bridge.
New Haven: The Pearl Harbor Memorial ("Q") Bridge.
Providence: The Claiborne Pell Newport Bridge