Pros
There are excellent benefits -- including childcare and adoption subsidies and the FREE public transit pass program. Stanford is a meritocracy, supporting and promoting those that show drive and accomplishment. If you work well independently and are driven to succeed, you will enjoy Stanford.
Cons
It's academia with its fair share of bureaucracy and red tape. If you are coming from out-of-state, it can be a shocker at how unreasonable the rental market is in the Bay area and specifically on the Peninsula. What you gain in benefits at working at Stanford, you lose in housing environment. In some cases it is easier to get a job at Stanford than to find an affordable house/apartment. With those considerations, it is often hard to keep good staff and faculty here.