I tend to agree with other commenters about looking for programs in queer-friendly cities, esp. if you're looking for an existing scene with nightlife. Minneapolis (U of M), Chicago (UIC), Boston (U Mass, probably others), Baltimore (Johns Hopkins, UMD), and Philadelphia (Drexel, Penn) are all big cities with BSN programs that I know of.
I wish I could provide more insight. Though LGBTQQI issues and relationships have been part of my life for a long time, I'm not queer, and therefore don't have any solid information about life at particular schools
. If you end up learning some good info, please do post it here so it can be shared.
FYI, there are no accelerated BSN programs in San Francisco; UCSF has a direct-entry NP program, and a number of schools in the area offer standard BSN degrees. New York has a couple of accelerated programs -- NYU and maybe Columbia, I think -- but since I myself don't want to move to NYC I haven't really looked.
(It's also worth pointing out that even SF, with its queer-positive reputation and infrastructure, isn't free of bashing or other hateful attacks on queer groups and individuals.)