Spent a bit of time there over the past 2 years for some racing so not too sure on the surfing side of things but the wave that comes in under the Golden Gate looks unreal and they SUP there.
Try these guys for hire, super nice guys and good shop,
bluerushboardsports.com/XX angie