I live in Toronto in a fully-detached home. Prices here are getting crazy and will continue to get more crazy as everyone wants to live here for jobs and new immigrants (of which there are many) want to be part of cultural communities.
When I retire I'll sell my home (currently in the $800K range but I'm guessing it will be double that or more when I retire in 20 years) and move out to a small community somewhere and bank a lot of extra money for my retirement. I enjoyed big city life in my 20's, but as I get older I just stay home more and more. I'd move out now but the city is where all the jobs are, and commuting is a nightmare.