Not bad for the price and room
I read the reviews about the location after I purchased so I was very worried when we arrived on how bad this place would really be. Unlike when we walked around Union Square, the mall or Fisherman's Wharf, not once did we get approached by some homeless person asking for something. Actually, homeless people were pretty scarce at this location compared to the homeless we saw sleeping in door ways at Embarcadero and around the Financial District. They seemed to be EVERYWHERE but this hotel so it was lovely. 
The room was great. We loved the decor and it fit the four of us well. I could complain about the double beds but even the 4-5 star hotels hardly offer 2 queens. It's as if the city penalizes them for it if they do. The beds were extremely comfortable and the room was very clean. The walls are pretty thin though but we hardly heard anything after 11 pm until 9 am. The days that we did hear commotion is because the window was open to the courtyard and I didn't realize it until two days later. My biggest complaint was probably the quality of the TV. The picture did not come in clear on any of the channels but since I was using it mostly for background noise, not a deal breaker for me.
James, the customer service rep who checked us in was very pleasant and cheerful as well as the gentlemen who provided our valet services. $28.50 a night for valet, BTW. Very cheap compared to other hotels charging between $40-57.00 a night. We had an woman of Indian descent check us out and she was lovely. She helped a couple find their way around the city, providing them with maps and cheap transportation options and was very efficient in getting us checked out.
It's a five minute walk to the BART and the trolley stop. If you decide to walk up to Powell Street, at one point it gets unpleasant with all the guys out front some of the shops smoking weed. You can easily avoid this with a $2.00 trolley pass.