While this would theoretically make sense, it's not actually very true in the United States. There's a significant speculative aspect to housing in some markets that results in price increases far higher than rents would sustain (this effect is actually more prominent in other markets, e.g. Canada).
Here: https://smartasset.com/mortgage/price-to-rent-ratio-in-us-ci... you can see that San Francisco prices are 50x rent, while Plano TX, which also has a high per capita income and low eviction rate, sits at 20x rent.
But it's still not obvious why for example Atlanta (22.6x) has almost double the price-to-rent ratio of Milwaukee (12.4x) if not due to speculation. Those both seem like fairly "typical America" cities to me. Would you expect Rent in Atlanta to spike heavily in the coming years? Or is the distinction you're making more about urban vs. suburban? (Since my link is just a mediocre blog, it's not clear if those numbers refer to city or metro area.)
Yes, because CPI measures cost of buying service of housing. Usually, if housing prices rise, so do rents, pretty much in accord, so monitoring rents already gives you a good view on housing affordability. The extent to which cost of renting is decoupled from house prices is largely explained by changes in interest rates: lower interest rates make mortgages more affordable, which allows more bidding for houses and pushes prices up. However, this on net doesn’t do much to actual affordability of said house: at low rates, the sticker price on a house might be high, but the mortgage payments will still be low. Conversely, in the 70s and 80s, boomers saw many cheap houses on the market, but at mortgage rates of 10-12+%, these were even less affordable than houses are today.
That’s why CPI only includes rents, to make an apples-to-apples comparison.