No, definitely not.

Most of the state is, obviously there are smaller places with historically famous queer scenes as well (Provincetown for example).

I would consider Boston as an area for your purposes, Boston itself is very small for historical reasons. It is also very expensive, in a very expensive state. Youve said nothing about your finances but this might be a concern. MA is great in my view, outside of cost of living. You’ll like it.