To choose a holiday destination, compare all the alternatives, then pick the best option.
Whilst I wouldn't go to Chiang Mai just for the gay scene, Bangkok and Pattaya are still good choices.
Anyone who disagrees might like to start by making the case for alternative destinations.