Wish I could help with hotels Vin but I havent stayed at any near the airport. But you are better off(rate wise) somewhere outside the City like Brisbane(near airport), there are very few discount hotels in SF or near Fisherman's Wharf. You can then rent a car or take a taxi into the City for dinner or whatever.
Will you have time for a smoke?
