This is one of the strangest things about the Bay for sure. It is like a stereotype of a sleepy little town this way. I stay in Oakland now, and there is one cafe (within bike riding distance for me) that is open to midnight.