I wonder if there's an inverse relationship between the ranking and the livability of an area
It's often the case, it seems, but not necessarily. My retirement location has a high score (91), yet it is located in an area with little traffic congestion, low taxes, low RE prices, and low cost of living in general. This is basically a high-tech enclave in a generally rural area. Excellent wealth-building location.