About what you would expect from a crowded Comfort Inn
Throughout your stay, you will be reminded that you are at a budget hotel. The lobby is drab, the elevators are quirky, the rooms are small, and many of the surfaces are stained. Rooms are fine, but no-fills. In my one-bed queen room, I had a dresser, desk, two sitting chairs, and flat-panel TV. There was also a small, open closet. The ice bucket and coffee/tea service are located in the bathroom, which I found a little unpleasant; there was a hair on my coffee tray, which was not surprising giving its location under the hair dryer. The room was basically clean, but the chair upholstery was stained, there was a faint orange splatter on one of the walls, and the bedspread had what appeared to be a cigarette burn. I opted not to spend extra on a bay view, so I looked out upon a building across a small alley, nothing exciting. Then again, it wasn't hideous either, and it was quiet. 
The amenities are what you would expect for a hotel in this price range. You get basic cable, free wifi, a hair dryer, an ironing board, and toiletries. There is no on-site food service after breakfast and no gym. 
The service at the hotel is minimal. You will be charged for such upgrades as a cot in the room or a bay view. If you ask for extra towels, blankets, etc. you'll be told to come pick them up at the front desk. Though a basic breakfast is offered, do not expect to find plates, cups, or utensils within a half hour of the end of service. The staff also stops busing the tables very early. Food items are promptly put away at 9:30 even if there are crowds waiting in line. When you check in, you also agree to some weird, small charge that you can later have removed upon request. I detest hidden fees like this, and I believe it's likely that the hotel counts on you forgetting about the small print before check-out.
Though the hotel's neighborhood is fine, there was a sketchy quality to the hotel itself that I was not fond of. You will also be asked to write down the names of all of the guests staying in the room when you check in. I'm not sure why this is, but I found it off-putting. When you key into your room, there is an extended, quiet beep after you open the door. It made me wonder if the front desk tracks comings and goings. The rooms and vending areas are also equipped with motion detectors. Maybe pricier hotels just do a better job at camouflaging these things, but I didn't like the vibe they put off. 
At the end of the day, I stayed here because I booked a month-long SF trip at the last minute. This hotel was available for nine nights of my stay in mid-July and the rate of $180/night fit my budget.