I like Chiang Mai & think that touristically it makes a nice change from BKK. However, the gay scene needs a major infusion of energy (& money) as better bars, clubs & massage can be found in BKK, Pattaya or even Phuket.
Shamelessmack, hard-working as ever, posted a number of reports on Chiang Mai at the end of January on his website:
https://shamelessmacktwo.travel.blog/
Unfortunately, i'd have to say that the reports are not encouraging.