Credit cards give the best rate, but the fees (at times) can make it a wash...
I've changed at a number of different places... Duty Free shop at the border, there's a motel about 10mins over the border, all the various kiosks downtown, banks, strip clubs, casino, airport....
Best exchange...