I realize this is pretty subjective, but there is not a single time that I have appreciated being in the fog on a bike ride or hike. It can be pretty to watch rolling in over the hills, but once I am in it, I always feel cold and miserable. I'd almost prefer that it just rain, because at least then I would have a valid excuse to stay home.
It's been a few years, so my memory might be rosier than the experience was at the time. I grew up in the PNW and it was a solid 10 years in the Bay Area before I could actually appreciate rain again. And I still hate it when bad weather ruins my plans.
However, one of my favorite scenic things here on the Peninsula is watching the clouds/fog crash over the coast range every afternoon in the summer. From a safe distance in my 70 degree neighborhood, of course.
