The stated objective of the Federal Govt, for some years now, is to get completely out of the housing business except for extremely isolated posts(of which we have only a very few remaining).This applies to the CF, the RCMP, Transport Canada, etc. Therefore there is very little incentive for them to do much about really overhauling the PMQs for the long run.
This is not helped by the fact that (IIRC) only about 30% of CF personnel live in PMQs, and this is declining as our pay and benefit packages improve.
Finally, I think you will find a huge difference in how the Services have looked after the PMQs. The Airforce has traditionally done the best job of taking care of its PMQ communities, while the Army has not done nearly as well. The Navy seems to me to have done not much better than the Army, and perhaps worse.
Cheers.