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."