Okay hotel, could be better for what they charge
What can we say, the hotel is right in the middle of Chinatown and has access to the bus and trolley (a few blocks up) so can't complain about that. I got my room on Priceline and read that they are not too nice to you if you do. However I called in a few nights before our stay (4th of July holiday) and requested a King bed on a higher floor away from the elevator. I didn't expect to get a view because I didn't pay for it. Then they asked how I got my room and I was thinking, "okay, guess I'll get the lowest dingiest room." when I arrived the check in desk was busy. Got to our turn, they were super nice and gave us a room on the 17th floor, away from the elevator with a king bed. Perfect! Also gave us 4 breakfast coupons which was great. One less meal to worry about. The room itself was small. Could have been bigger if not for that weird desk. I assume it was a business room prior? Decent size bathroom. But the room could use some work. There were some holes in the ceiling and the floor in the bathroom looked like it was patched together in the corners, and additional holes there too. When we arrived a maintenance man was fixing a drawer handle that came off and left. Not sure if it was super glued or not but it came off again anyway. Hope we aren't getting charged for that. The window itself was very dirty as others said but I only got a view of some building anyway. I didn't notice too much noise at all where I was at. Not too much hallway noise either. We parked across the street at Portsmouth for $27/day. No in/out accesss but we got the city pass so the trolleys/munis are free anyway. Pier 39 was also only about a 15 min walk so no problems there. The breakfast was decent. I guess because I got it free I can't complain. Service was good and they were real nice all around there. Downtown is downtown. So I feel like it is the same with noise and cleanliness. My husband said in the future he would stay at hotels in Fishermans Wharf instead. 
Just FYI, if ou plan on riding the trolley, either do it in the morning or at night. It gets packed and isn't really stroller friendly. Or at least go to the main turn arounds to line up. Otherwise you will wait forever as one of those stops with no guarantee to get on at all. The muni schedule is easy to follow. Kinda dirty though. A couple of bloody seats on out bus. Yuck! If you have kids and strollers, I suggest walking or car. Good luck and happy travels.