We stayed at the Hotel Adagio for 2 nights over Labor Day, having found a great promotional rate of $99 a night through hotwire. It is very conveniently located near Union Square (great shopping and you can also hop on the trolleys there) and also only a short walk from the BART stop, which we took to and from the airport (fyi--this is very quick and easy and saves a bundle on cabs).
Though the hotel was still working a few kinks related to the renovation (e.g. humidifiers in the hallways), we could not have been more pleased with the experience given the rate we paid. They clearly spent the most money redoing the lobby/bar area, but the rooms are also very comfortable and the staff is eager to please. The lobby has a beautiful selection of coffee and teas each morning and afternoon as well as complimentary fruit as an afternoon snack.
I am not sure I would pay the full rate to stay here but if you can get a discount then I would highly recommend it.
hotel reviews