Keep in mind that most summer mornings involve marine layer until 10AM or so. Unless it's really hot (which it does appear is going to happen over the next few days). Sightseeing over the marine layer is not necessarily boring -- the Golden Gate Bridge towers often poke through it, for instance, as do almost all the mountains around the Bay. But of course an instrument rating will be a must.
The really good stuff, IMO, is the coastline, however.
Unlike DFW, summer afternoons may get a bit of mechanical turbulence below the mountain peaks (around 3000 feet west of the Bay and 4000 east) and some moderate winds, but thunderstorms in summer are exceedingly unlikely west of the Sierra. When it's hot, it's very dry.
While a Class B transition at 1500 is possible and is very scenic over the City (watch terrain -- there are obstructions higher than that!), I don't recommend it in the afternoon due to turbulence. 3500 is much better.