I would stay here again!
The hotel is just about on the limit of being too far from all the attractions of San Francisco. You can easily walk to Union Square but you would have to take a Cable Car to get Downtown or to Fisherman's Wharf and Pier 39, Golden Gate Bridge etc. But it's a great excuse to hop on and off! 
The hotel staff are very friendly and helpful, the rooms are very clean and comfortable. There is a cheap shuttle to get you back to the airport too.
The Entertainment and Wine Tasting at 5:30pm is a must!!