I sometimes use this website to read about cities if a good school has an opening, but I don't know enough about the city it's located in. Most reviews are by embassy staff, but it will nevertheless give you a sense of the different cities, and how it is to live there as an expat: https://www.talesmag.com/real-post-reports/all
They also have a section where they review schools (as parents): https://www.talesmag.com/real-school-reports/all