Cost of building a tower is much more than something like rowhouses, multiplexes. Cities like Toronto and Vancouver bypass the "missing middle". So it's mostly single family homes with various "tower node districts".
Yes, towers are expensive, but building them doesn't make the existing SFHs more expensive. Maybe tower building and rising home prices both coincide with certain economic trends, post hoc ergo propter hoc.