I've heard good stories about the smallie fishing in the Millers but never tried it. If you want a July smallie trip, my vote is for the Housatonic... I have some experience there and I know I can put on fish there, the only question is how many you will catch. A typical July/August 4-8 pm fishing excursion has provided me 30+ smallies.... I have had all day trips when I have caught triple digit numbers.
Another idea is to float the CT river from Enfield dam down to Windsor Locks. I have a canoe but haven't managed to get anybody to do this with me so I have always been stumped with the putin/takeout transportation issues.
Where in CT did you live? I lived in Windsor for 29 years....