Yes -- Star Alliance policy is that premium cabin pax and *G are entitled to hotels for overnight delays on international itineraries (regardless of cause). SFO has weather problems whenever ceilings are low and/or winds force a cross pair of runways out of use. They can't do parallel approaches except under VFR so it cuts the acceptance rate below the schedule and causes havoc whenever it's foggy in San Francisco
That's too bad about the agents.. I've seen a lot of stories about bad apples in SFO but never had many problems myself.