I'm sure it's great if you can afford it. CT is an expensive place to live. And averaging states is problematic because they are not homogenous. Nice neighborhoods in every state are going to outcompete rough parts of New Haven by any metric.
Exactly. For example, this has Illinois ranking above Indiana, yet we have tons of companies moving there, their economy is doing a lot better than ours and I bet you'll find next to zero people living in Indianapolis or Bloomington wishing they lived in the Land of Lincoln. They have about the same REAL (adjusted) standard of living and lower taxes/costs...
Growing up in Wisconsin, I would never want to live in Indiana but would live in Chicago in a heartbeat.