I had a very nice stay at Hotel Abri. The staff was genuinely welcoming and very helpful and I was upgraded to a suite, which was a nice surprise. The lobby feels very modern and the room has nice updated furnishings (apart from a slightly worn couch), but it still has the vaguely musty smell of an old NYC apt. and feels a little old, perhaps because of the older real wooden doors and big windows (which actually gives it more charm).
As others have mentioned, the free wifi was iffy, the bed was VERY comfortable, and having a courtyard room made it nice and quiet. The location is fantastic, especially for tourists interested in riding the cable car, or anyone who wants to be close to the very convenient Powell St. station, Union Sq. shopping, or SOMA area.