I once was heading for Morro Bay when the CG was airing an advisory on
VHF 16 that the bar was breaking and the harbor was closed. I'd just sailed down from Monterey in two days of Force 8, so we were bummed to have to continue on to Port San Louis. We arrived at 0200h and, just as Randyonr3 said, the fog broke right when we got to the harbor entrance, and we could see stars above us for the first time in three days.
Be aware that the Morro Rock will shield
VHF broadcasts along a cone radiating from the harbor office. That zone is marked on some
charts.
The folks at MBYC are cruiser friendly, and have moorings available for boats from reciprocal clubs. It's an all-volunteer club, so don't expect regular restaurant
service, et cetera. I've gotten land-sick dizzy in their
shower a couple times, so be forewarned.
Three boats ago we ran out of CNG shortly after departing Santa Barbara, so we pulled into MB to pick up a bottle, since it's such a busy
fishing port. We were shocked to discover that CNG wasn't available there. (Which is why the two boats since that one have run
propane.)