Great location - Tired hotel.
My wife, kids and I stayed here in July 2012 on a road trip from Seattle to LA. We had a fantastic experience with the Holiday Inn Express in Astoria, Oregon about a week earlier.
The location of this hotel is good, it is dead centre of the Fishermans Wharf area. Lot of attractions, restaurants, bars, tram stop, nice walks from the hotel.
The hotel itself was very tired and to be frank quite over priced. Staff were friendly, polite and helpful. But the building is in dire need of a make over. 
I would stay there again, if the hotel had a face lift. The location is great, the brand is good, the staff were great but the building was tired.