You can use a general rule of thumb and say that better the education level and income, the fewer the problems. Hence, leading places like SF/Seattle/LA are all fairly affluent and have large segments of the population with at least some college.
And, speaking of college, university towns are good, or at least better. Just make sure its a huge Liberal Arts type college and not an Agriculture College/Engineering School, so Austin Texas with the University of Texas, yes, College Station not so much. Ann Arbor MI and Madison Wisconsin, UofM in Minn/St.Paul are all pretty good I hear.
St. Paul and Austin share something else that good TG cities often have, which is a state capitol. Capitol cities, Des Moines, Denver, Sacremento all seem to have a sleezy underbelly which covers TS to a degree. I have a theory as to why this is true about Capitol cities (and Madison is also a Capitol) but that does not matter as much as wherever the capitol is tends to be the most liberal place in the state, and also a bit more lawless.