Perfect location for the waterfront
We've stayed here on a number of visits to San Francisco and it does the job well. 
The rooms are spacious and clean, though a little dated. The facilities are good in the rooms not that you'll like spend much time in them. The beds are comfy and we slept well during our stays. 
The bathrooms are basic but clean and have a good shower. 
The breakfast buffet is pretty gruesome in terms of quality of food and selection but you get used to picking through and finding something. I couldn't eat like this everyday though - it's kind of what you expect in the US but coming from the EU it was really far from what we were used to being served, particularly from a quality point of view...
The hotel location is perfect for the waterfront in that you can be by the water in a few minutes walk. There are plenty of bars near by but generally its better to head into North Beach for food since the water front is exactly what you normally get where tourists are found; expensive and inedible. The hotel is also very close to the drop off and pick up for the city tour.
One of the nice features of the hotel was that having rented a bike for 24hrs, they hotel happily let me store it in our room over night so I could use it the following day. This was unexpected but very appreciated. They were also pretty good with getting us cabs and an airport limo etc. 
The hotel is definitely overprice for what it is but so are all the hotels in this location. Overall we have always had a good stay here and I'd recommend it to others.