I am in Connecticut.
I actually live about a mile or so from the Colt factory.
As far as LGS, there are several good ones. I am in the process of trying to put together as comprehensive a list as possible for Connecticut Local Gun Stores.
Off the Top of my head, here are some of the ones I think are really good:
Newington Gun Exchange (NGX), great people, not a huge store, but what they have is really good.
They get a lot of Colts, CZs, Dan Wessons and have a lot of used Sig Sauers and Smith & Wessons. Great people.
JoJo’s in Southington. Small retail space, but they do A LOT of custom Smith work. They have worked on several builds for. I recommend them.
Sportsmens Outpost in Wolcott. Good people, and a good array of guns. I have not been there in a while, but they typically have some good 1911’s and Revolvers to go with the array of modern stuff.
The Gun Store in Waterbury. Real good inventory. Some of their used stuff is marked high, but they have a lot of Wilson Combats and Nighthawks.
Hoffmans on the Berlin Tpke. Huge selection, worth checking out, especially if you are making a trip to Newington Gun Exchange. Check out Hoffmans too.
I will add some others that are not local to me.