We stayed here for three nights near the end of July 2012.
The benefits of this hotel are easily summed up: price and location. You'd be hard pressed to find a better deal this close to the Wharf and Pier 39 - they're literally a few steps from the front desk of the hotel. Of course, this could very well lead to all the money you saved booking a room here being lost after all as both of these tourist traps loaded with eateries, gift shops and "fun 'n games" are nearby!
One of the other major perks of this hotel is the free parking for guests. This was the first time we visited San Francisco, but we've heard that it is near impossible to find (affordable) parking in the city and that many hotels charge you for parking. Suffice to say, we were very pleased. The parking spots aren't abundant though, so we opted to park the car when we checked in and didn't move it again until we checked out, relying on public transit to get around the city. There is a tram station (F-Line) within walking distance from the hotel which gets you to Union Square rather swiftly, so this was ideal. Also, there are a few bike shops nearby where you can rent bicycles to explore the city (and perhaps cross the Golden Gate bridge!) however you'd like to.
The employees at the front desk were helpful and above all, glad to help us. However, they did cause a mix-up with some tickets we purchased through them for a bus tour of the city - they apparently sold us tickets which were incorrectly priced (i.e. too cheap) leading to us not being admitted to the bus. Luckily, the bus tour office is across the street from the hotel so we were able to get it sorted out soon enough.
The room is nothing fancy, though it is spacious considering how little it costs! The bed was fine, as was the bathroom. Free WiFi is provided. The room was clean, but a bit dated both in terms of interior decoration and architecture; few sounds are blocked by the walls. You could hear other guests walking in the corridors and you could also hear everything going on out down on the street (we slept street-side). At night-time there were the occasional cars playing very loud music parked on the street and also, homeless people shouting at one another. Thankfully, access to the elevator and stairs is only granted by a room card, so we felt safe in our room at night.
If you are visiting San Francisco for the first time and feel like you want to be near Fisherman's Wharf and Pier 39 (and a little bit farther, Lombard Street), I believe this would be your best bet unless you'd rather spend more money for a bit of luxury. However, if you'd rather steer clear of the tourist traps and relocate in the direction of Union Square (shopping and tall buildings) and the variety of famous parks, streets and architecture, I'd recommend you stay elsewhere.
This review is the subjective opinion of a TripAdvisor member and not of TripAdvisor LLC.