Not sure where you're moving from, but I moved to New England from Dallas, TX. I was in the Worcester, MA, area for 2 years and have lived in East Providence for over a year. My general take is that people in NE don't care about your sexuality. For context, I'm a 40 yo queer white male.

Having said that, downtown Providence can be a little rough at night depending on what's happening. There was a weekend festival going on and I was downtown having a good time. I told a guy on the sidewalk that he was hot and he assaulted me.

As mentioned previously, Stable, Alley Cat/Dark Lady, and Eagle are the main queer bars in PVD. All are within walking distance of each other and have friendly vibes. There is also EGO, but it's more for the folks in their 20s. There are also a couple of places specifically for extracurricular activities.

Not sure I would live here without a vehicle, but I guess if you're only staying downtown that could be fine. There is so much of New England to explore with a vehicle. Make your way out to Provincetown.