Definitely Misdirections Magic Shop. I used to live 2 blocks away and it is the best in the city.
If you're staying downtown, you'll need to take a muni/uber out a little ways to the Inner Sunset neighborhood, but the quality, selection, and knowledgeable staff is far superior compared to the...