Great Thread Jay!

My flight experience is limited, but I still have a few to add:

SF Bay Tour - To do this right, fly out of either HWD or OAK, take the
Nimitz freeway north departure. Sunset is generally the best time of
day, both because of glory of watching the sun set over the pacific,
and because that tens to be when the fog literally spills over the
Marin and Peninsula Hills into the bay like water. After a few loops
around the SF downtown, alcatraz and the Golden Gate bridge, request
the Bayshore freeway Bravo Transition South (often your routed right
over midfield SFO, with 747's landing 1500 feet below you), Head down
the Peninsula to SQL, and then slink under the SFO 28 approach
corridor (caution wake turbulence) back across the bay to your point
of origin.

Yosemite - If you're going to do Tahoe, you might as well slip down to
Yosemite. I've only done this once, but the route I took was the fly
up the Hetch Hetchy valley and then back down and out the Yosemite
valley. 13500 is really the minimum altitude to assure that you won't
bust any aviation law (which kinda annoyingly high), but with good
planning and a GPS you can drop significantly lower. After your
flight land at Mariposa Yosemite (MPI), beautiful little field at the
mouth of the Yosemite valley with cheap gas. They've got a BBQ pit
right next to the transient parking, so bring so charcoal and a few
steaks to top off yourself