There are actually a fair number of folks that commute from Canada to the US for work. They will generally have TN Visas, it is certainly not "unthinkable" - it really does happen, although I will confess that the only folks I have ever met that did it were not recommending it to anyone else!