If Ikea and Motel 6 mated
Note: I NEVER write reviews, but in this case, my recent experience (7/8-7/10) compelled me to give warning to anyone staying here.
The rooms were awesome-ly designed, very bright and cheery straight out of an ikea catalog. Although if you're over 6 foot in height and weigh more than 200lbs, getting into a mini-cooper will be less of a challenge then taking a shower in their bathrooms.
The Beds were surpisingly comfortable compared to the over hyped air mattresses the Radisson across the street sport. 
BUT whoever was in charge of revamping this building had deaf people in mind. The walls, floors and windows are as thin as wafers and thus noise came in and out of the rooms with ease. Upon checking in to our 3rd floor room, we immediately heard what sounded like track and field olympic trials in the room directly above; even while taking a number 2. Being a night owl and a light sleeper this was unacceptable. Being that this hotel charges more than $200+ for rooms makes this completely and utterly unacceptable. If i was in a motel 6, paying 39.99 a night, okay fine, you get what you pay for. But, to pay $200+ and be put in an SPG room, AND at the same time hear your upstairs neighbors kids do the macarena, is ethically wrong.
Logically we thought the 4th floor room would be less noisy (since this was a 4 floor hotel), we were wrong, as the thin windows over looked the valet parking. We heard inebriated jibber jabber from the guests in the fire pits below for a good hour or so. On another note, the windows are NOT tinted, and upon entering, we were greeted with a direct view of a guest in a room directly opposite of us naked, changing. Although i'll admit, If it was an attractive lady, I wouldn't have been as appalled. In addition, the window pull down shade isn't very sun-block friendly. So if you are a vampire, a night owl or like to sleep in, this hotel is definitely not for you. 
Finally, the front desk is bi-polar. When I checked in, the nice young asian lady who assisted me was VERY helpful, friendly and accomodating. Two nights later, when our San Francisco trip got unexpectedly lengthened and we were frantically searching for rooms at midnight, the night time front desk guy named "Roy" gave us the run-around, made excuses like he was helping out a tour group (at midnight), never answered our calls, avoided us. Very rude, considering we just spent a grand at that hotel the past two days (the homeless guy opening the door at the nearby 7-11 should teach him some manners). Luckily the night time guy at the Radisson across the street was VERY helpful, friendly and accomodating.
***Stay here only if you get a 4th floor room, don't mind tiny bathrooms and rude staff members named "roy". In addition, bring a box fan like i did. Sleeping with it on in combination with the a/c will drown out most of the noise that creep in from the window (depending on the side you are assigned).