The rumor mill has been running overtime lately, and it looks good for the Canada-USA border to reopen fairly soon.
https://www.flightglobal.com/networks/us-lifts-do-not-travel-warning-for-canada-mexico-much-of-europe/144062.article
What we are hearing up here in the Great White North, is that restrictions will be slowly lifted. The 14 day quarantine would be waived for travellers who are fully vaccinated who can show a negative test, so if the USA reciprocates, that will mean paying for a negative test going in and a negative test coming back. That extra cost would definitely reduce day trippers. We shall see what the official announcements are soon.