I stayed here for work for a total of 10 nights. On arrival I was disappointed by the location out of San Francisco but then I didn't book it so had no say in the matter. I will however comment on the actual hotel as I am sure you can look on google maps and see where it is and make your own judgement.
The hotel itself is nice, right on the water front and if you have a room overlooking the river you won't hear the traffic at all, I left my sliding door open all night instead of air con.
The rooms are large with comfy beds and pillows and a little kitchen area that has pretty much everything you need fro a short stay.
They have a free meal from 6 till 7 in the evening which is a nice little touch if you are working. There is no bar which is a downside, but about 10 mins walk away is the lighthouse pub, which is fantastic.