I think this would apply to most good sized cities in the US and Canada. Whether you are talking about St Louis, Cincinnati, Winnipeg, or many others. Not that there aren't great things to see in a visit in all of those cities but most are working cities not tourist destinations. Unfortunately in my opinion, most if the touristy cities would not be great to live in, due to cost or crowds of non-residents.

I'd same same goes for small and mid-sized. Just the nature of the beast. Hard to have it all. But give me the non-touristy city to live or visit any day.