My credit/debit cards are of course all from U.S. banks but seems the exchange rate is set by the Canada bank that owns the ATM.
I am also charged a typical $3.50 ATM fee but my bank immediately credits it back.
I tried what Einer suggested and ordered $CDN 500 from my bank a few weeks before I left to see how the rate would be and have some $CDN when I landed. However, the exchange rate was terrible.
Einer's Western Union suggestion I just checked on. What if I sent $1000 to myself to be picked up on Canada at a WU office which of course would be in $CDN. I used WU price estimator and if I paid in $US.
If I paid in cash with $US1000 the WU fees (but no clue on what exchange rate would be) the cost would be (all in $US):
Pay credit/debit card $95 transfer in minutes
Bank account $19.99 transfer in 4 business days
Pay in store (cash) $10.00 transfer in minutes.
However, then footnote 2 says:
Western Union also makes money from currency exchange. When choosing a money transmitter, carefully compare both transfer fees and exchange rates. Fees, foreign exchange rates and taxes may vary by brand, channel, and location based on a number of factors. Fees and rates subject to change without notice.
Conclusion at this point is to just find a RBC ATM since at least on this trip that was a no cost way from a debit card of getting the real xe.com exchange rate which was rounded $0.77 and quite stable last few weeks. Now that I got back to Phoenix the rate got slightly better last 0.759 per xe.com
Or, using
https://www.finder.com I find four money transfer services that give me .756/1.308 to 1.312 reversed depending on how fast need transfer. Slow is fine since I get flights and hotels more than a month before trip.
Today had a long talk with a older client planning a trip to Toronto to visit his kids. He knows I am a bit of a Toronto travel person. Decades ago lived in Montreal and has dual citizenship. He also gets a Canadian pension and and his wife have four RBC accounts. He only has bank accounts and credit cards with RBC (in $CDN so no currency conversion issue). It is usually expensive to get a cash advance from a credit card vs no cost on a debit card. After my suggestion be called RBC (on Sunday) and was told they could issue a debit card for any account but have to come to an RBC bank to do so, not just send to his Phoenix address.
Also I directed him how to get fare quotes for Air Canada which is the only non-stop now from Phoenix - American dropped a few years ago and Southwest only goes to Buffalo. When SW was much cheaper have gone to Buffalo, enjoyed strip clubs in old days in Niagara, then Hamilton and drove to Toronto. But Air Canada is less expensive now direct to Toronto than Southwest to Buffalo.