California's a big state.
Then again, 3 weeks is a long time.
Are you planning to spend the whole time in the San Francisco area? Or will you be driving around? Do you guys enjoy outdoorsy things (hiking, camping, etc.?)
The weather will probably not be super nice in San Francisco in August, but it will be in other parts of the bay area. Just not in San Francisco itself (lucky us
)