As people wrote, Canadians cannot drive a US registered rental car into canada; I don't think there is any problem if the car is privately owned. If you request in advance, a Canadian registered car can be arranged for you. On a couple of occasions Microsoft did this when I was visiting Seattle (though they have a special agreements with Avis).
As for OW rentals, these can also be expensive to arrange privately. Microsoft seemed to get this for free.