The lay of the land may be different in Canada than the States. Oh, sure, both have varying subsidies and such. But at least down here utility companies are seeking to add base charges to houses on solar to cover their infrastructure and make up for lost revenue, and lessening how and when homes get credits for energy released back into the grid.
As far as on-site consumption goes, it's gets complicated depending on who you are and when you use power. If you store it for non-daylight hours in the fall/winter/spring you need battery packs that degrade over time as well. But unless you're retired and then just go to sleep at night, running a wood stove/furnace for heat, most of your consumption will be at times you don't generate....
I've looked at it quite a bit, mainly because I'd love to get into a family compound situation. I want a driveway at least 1500ft long and no neighbor visible day or night. Found an Addams family style house but major inspection issues had us not go through. Since then we've been checking in on a couple 100-250 acre properties but I'm not impressed by the lack of maple/beech/cherry on the properties.... it's heavy pine/hemlock with some oaks mostly. So some minimal grid connectivity would be nice, but like I said.... issues.. .