I moved here unwillingly 14 years ago and it's never been a great place to live in my experience. It was dull and boring when I arrived and it still is. The expat population was (and probably still is) significantly older than it is in Bangkok. Walking around Airport Plaza when I first arrived was like walking around an old people's home. Every single Westerner I saw was well over 60. There's nothing wrong with being older of course but if you're under 50 and still active, I don't think Chiang Mai is a good place to live.
I mentioned some of my concerns on this very forum back then, which included food, and was met with hostility from posters, one of whom went so far as to claim the choice of restaurants in Chiang Mai is every bit as good as the choice in Bangkok. I gave up trying to have serious conversations on here after that. The city is dirty, unattractive, congested and attracts the type of visitors I could cheerfully strangle: posers, hipsters, digital nomads and neo-hippies who wander around SEA in search of authentic experiences, man. It also attracts the type of expats I dislike: older Westerners on a fixed income who are unable to see the irony of their bigoted attitudes, having chosen to emigrate here. Most of them pair up with a native girl whose history is better left undiscussed and slowly drink themselves to death.