Hayes Valley is kind of the mecca for those with a sweet tooth. We've already covered Christopher Elbow and Miette. And if you aren't satisfied with the options at these two places, there's always Paulette Macarons.
If you go to Paulette, you should know that they have a picture taking policy. The policy is this: you have to ask. You can take a picture but if you don't ask first they will say to you, "excuse me but you have to ask". And then you will say, "I'm so sorry, can I not take photos in here?" and they will say, "yes, you can. But you have to ask".
I prefer the non-fruit flavored macarons. These here are some combination of espresso, vanilla, chocolate and coconut. And while they were all excellent, the macarons at Bouchon Bakery remain my favorites.