Cities like New York and San Francisco are known for being LGBTQ-friendly. But these six smaller cities deserve a closer look too.