If I were you I'd start flying into SJC (San Jose) instead. I am a Gold and routinely get upgraded on that route. You can then take the Cal Train to San Francisco or rent a car.
Also, I have been upgraded on the redeye SFO - IAH flight every time I have flown that route (on a Tuesday night/early Wednesday morning), even as a Silver.
Good luck!