LA Metro, DC Subway, Seattle Sounder, BART, all seem safe to me. However, I've ridden the LA system through South LA and parts of Hollywood with um, less desirable, patronage. So I tend to stay alert.
Also, I spent a weekend in SF in November, walked all over the Financial District, Market St and the Wharf, and never encountered any of the problems often mentioned re: homeless and droppings.