I think the best summary of this is the Bank of Canada's recent statement that, yes, there are industries, consumers, etc., that benefit from low oil prices in the way you describe, but on the whole Canada is a net oil exporter. We are a resource economy to some degree, although not to the degree often painted. On a net basis this is going to be a negative, but that doesn't mean that it's a huge negative and that doesn't mean there aren't positives buried within. Transportation is the easy one.
On March 10th, 2015. See this statement in context.