Would you make a profit selling a home in Canadian dollars or in American dollars?

Depends on where you are selling the house and how much you sell it for.

If you sell a house in Canada, you will be paid in Canadian dollars. The legal currency is Canadian. If you sell the house for a profit, then you make a profit. If you sell it at a loss, then you don't make a profit. Whether you are dealing in Canadian or American currency isn't relevant. It's what you purchased the house for and what you sold it for that determines if you make a profit.