Really? Have always found it has more character and class than most any other Thai city of comparable size--the mountain, the moat, the malls, the green spaces, northern architecture, leafy old town lanes, stunning temples, great cafes, close airport. Most other Thai cities are incredibly bland in comparison.
I wouldn't stress too much, just find an area and try it out then come back for a few months. If it doesn't work out, move on. You likely won't scratch the surface going here and there.
This area around Sakorn Residence is nice and within walking/riding distance of town: