Hi J.,
I gave birth to my son at CPMC. Overall we had a good experience. It was a pretty well-oiled machine and it seemed like just when I was thinking that I needed something, the nurses would magically appear and change my pad, offer me juice, ask if I wanted to nurse the baby, etc. The nurses were pretty responsive except for one, but we only dealt with her once. (There's always one stinker nurse at every hospital, of course.) Also, lactation consultants come around every morning and hold a "class" on how to get your baby latched on properly. They also have a nice store called "Newborn Connections" where you can find anything you need for your baby or you (like nursing bras--they will fit you.)
If I remember correctly, the hospital said it was pretty rare that you don't get your own room there. Even with another local hospital closing and a lot of those moms sent to CPMC at the time of my delivery, we still got our own room, which was fairly large. They are very supportive of "rooming in" and will provide a bed for your husband. Any time I called for help, the nurses came right away. Meals were actually decent (included Chinese food) and delivered to the room. The only thing I didn't like (besides the one grumpy nurse) was the drive into the City (although it's pretty smooth, and when you are on your first kid there's usually no rush to the hospital anyway), and the parking situation is kind of screwy. Your husband will have to park in the 20-minute parking, get you admitted, then move the car to the 8-story non-handicapped accessible parking garage with no elevator. Then he'll need to trek down 8 flights of stairs with anything else that you need from the car. If you haven't done so already, you can call to make an appointment to get a hospital tour and see how you feel once you get a look around.
I didn't deliver at Stanford, but my father was there for 4&1/2 months (was supposed to be 7-10 days) because he got a staph infection in his wound after they performed cancer surgery. I would never want to stay there because 1) I obviously am completely sick of that place and 2) I get the feeling that they have a high infection rate.
If you have the option, Mills-Peninsula in San Mateo is supposed to be the best. If we are still living in San Bruno when we have a second child, we are definitely going there instead. All the moms who have their kids at Mills-Peninsula rave about it. They also have an excellent breastfeeding support group every week downstairs if that's something you're interested in.
Good luck!