Guilin, China

With a population of over 4.9 million, Guilin is a major city in China's Guangxi region. However, beneath the picturesque scenery lies a bureaucratic headache - the city's public transportation system is still a work in progress, with the metro network not expected to be completed until 2040. The climate is also challenging, with short, mild winters giving way to long, humid summers that deliver nearly 1,900 mm of rain per year.

While Guilin may be renowned for its stunning karst landscapes, the practical realities of living there are a mixed bag. The GDP per capita of ¥41,891 (around $6,569) suggests a reasonably well-off city, but navigating the administrative complexities and unpredictable weather could be a persistent headache for many expatriates. Ultimately, Guilin may be better suited for short-term visitors than those seeking a permanent relocation.