Free internet is like tap water required if you want guests
Spent 5 nights in San Francisco staying at the Handlery Hotel. The old hotel is a bit of a rabbit warren. The hotel is just down from Union Square and has good access to shops if that's your game otherwise public transport will get you round the city if you are prepared to give it a go. Its about a 20-30 minute walk to the ATT stadium for a Giants game which is worth a look even if you have no interest in baseball just to observe the locals and look out over the bay. Get top tier block 317 seats for over the plate and over the bay views and a good night. The walk home is no problem so hoof it for a look at that end of the city. 
The staff are good, the breakfast choices pretty good but watch out for the portion sizes, huge, specify exactly what and how much you want otherwise you will waste a lot or bloat yourself.
 Our room had a view of air conditioning ducts so this is not a hotel with a view but was reasonably quiet. The room was clean and well equipped. There are a number of bars and restaurants nearby. Try the Clift, Redwood bar for Philippe Starck out there decoration, the Grand cafe for french food in a grand setting, the Millennium for good vegetarian fare, Lefty O'Doules bar for a Giants baseball sports bar experience.
Unfortunately the hotel let itself down with no free internet. As far as I am concerned you can get free internet in the worst dives in the US these days and a hotel of this 'standard' has no excuse for not having free internet hence my poor rating if it had free internet it would be average to very good