Hydrostatic pressure is the main mechanism on the hillside neighbourhoods. After days of winter rain, saturated soil holds water against the foundation wall and pushes it through any crack, cold joint or tie-rod hole. Farm Hill, Emerald Lake Hills and the upper Woodside Road slopes see this reliably in wet years.
Surface water is the more common cause on the flats and downtown. Grade that slopes toward the house, a downspout discharging next to the foundation, a driveway that drains to a garage door, or a window well without a cover. This water arrives fast during a storm cell and stops when the rain does.
The third route is the drain itself. When the municipal line is overwhelmed in a storm or a lateral is blocked by roots, the lowest floor drain in the house becomes an inlet. That is a Category 3 event and it is handled as sewage work.
And near the bay, there is a fourth factor: a high water table. In Redwood Shores and other bayfill areas, groundwater sits close to the surface, so below-grade spaces dry slowly and any breach re-wets quickly. Drying schedules there are longer by design, not by accident.