I live about 45 minutes south of SF. When folks talk about it being overpriced, the accomedations can be so, as can the galleries, but I find that's the norm for most 'art colony' places around the world. If you plan on visiting the museums and just doing window shopping, I think SF is pretty reasonable.
You must visit the plaza. It's great during the fall when the wind is blowing, slightly. Also, I like the Loretto Chapel with its neat stairway.
As for eats, there are plenty to enjoy. I like The Shed, Zia Diner, and Guadalupe Cafe.
You might like this link;
http://sfreporter.com/articles/publi...6-shopping.php