>We are in a super trans/homophobic area rn and are really trying to move somewhere better.

Really not trying to discourage you whatsoever, there are TONS of amazing places in CT that support this, but as a local I do not think of the Farmington Valley as the go to. There are so many amazing options in the direct surrounding towns/area that are better options IMO. Farmington has some old school snobbery, but like other commenters said, you're dealing with such few cases it's almost a non factor