Red Roof, if you can get it, is supposed to be around $60, but yeah.
Last I heard it was still decently affordable, by Bay standards. (I don't need it - except when BART wets the bed - but that doesn't happen often)I thought they got rid of the crew rate.
Book the Red Roof as far in advance as possible. The best rate I've ever scored is $65 there. VX floods that hotel and the crew rate is rarely available inside of 24 hours.
SFO can be scary because I've been stranded there a few times and ALL hotels were over $400. Even the Travelodge was asking $380 for a "crew rate."