It's extremely dirty! Cockroaches. Sticky tacky visibly unclean floors, greasy toilet levers, dirty dresser, dirty sheets towels, dirty shower, pee on toilet, etc
It's run down. The carpets are soiled and smell like cigarettes. The shades are stained and sticky. The paint is layered thick on the trim. Etc.
The neighborhood is terrible. Food, cardboard, and needles strewn about each morning by the drug addicts and mentally ill who live outside on the block. People selling drugs. Groups of ~15 blocking the sidewalks.
Car situation blows. They list onsite parking but it's a block away run by some shady Russians who tell you that you can "in and out" is included when you park for $40 but do not honor that and charge you again. Street parking is allowed if you move by 6am but your car will be gone through and/or have it's windows smashed even under the main door cameras.
It's a rip off. $80 per night becomes $95 after fees. $95 which becomes $110 if you include a bathroom (the room changes during checkout to not include a bathroom). $110 becomes $150 due to parking. I would have preferred to sleep in the car or anywhere else for that matter. The motel in Mountain View was nice enough and $80.
For the positives; it is right downtown and if you go 4 - 8 blocks or so in any direction it gets a little bit better. There are a lot of boarded up places but there are also some really nice establishments. Staff was friendly. The people watching was great!