Great Location but Horrible Service & Fraudulent Charge on Card- Awaiting Full Resolution as promised
I will update this review once I receive the resolution I was promised by the GM. I had the misfortune of staying here from 09/05 to 09/07/2012. This hotel was the only bad thing about my first visit to San Francisco, but I thought that it would be the BEST aspect during my check-in with Edwin and Hugo. However, things went downhill quickly. 
I found that my room could have been cleaner. i really disliked finding condom wrappers in the trash can, an OB tampon wrapper on the floor, and a filthy rag on top of the AC unit. However, I would have let everything slide if housekeeping would not have been rude. I had called to request forgotten toiletries, and was given a stern lecture by Rimel once he arrived an hour later. I was chided for asking for too many items, but he would hear no reasoning from me. So if you stay here, be aware that they give TUBES of toothpaste, not packets. This may save you from beiing treated like you are that poor that you have to rely on the Holiday Inn to supply your toothpaste.
The preceding was the beginning of a downhill spiral for me & my family at this hotel. I spent hours dealing with management about the lack of respect that I was shown, but things kept getting worse. The slow internet was an afterthought for me when compared to the my dealings at this hotel, including my little one hearing restaurant employee Hector (who I never even dealt with) call me a derogatory name. Management (not the GM) told me "at least the meal was free" when I spoke of this issue. Itwas evident that management thought that gradual discounts would pacify me, but all I wanted was respect. I felt like I was purchasing a car when dealing with this hotel, but the product that we were negotiating was to be treated right. I did get the respect that I am used to from traveling 100+ nights per year once I checked in somewhere else. 
Three days after checking out of the hotel, I was stunned to learned that the night that was supposed to be free was mysteriously charged to the card. They went back on their word! I immediately called my bank to close the card. I finally did get GM Sheila Martin on the phone, and she was sympathetic and understanding, but also unaware that I had any issues. She did agree to refund my entire stay, and called back to confirm. However, the card they issued the credit on is closed (due to the unauthorized charge for one night from them). My bank said that it will not go through, and I have to give them my new card number. At this point, I only feel comfortable talking to the GM. I'm hoping that I can get this resolved soon, and will update my review once this is resolved. 
In closing, the only thing this hotel has going for it is the location. Any good experiences were mostly marred by the bad. As a professional who stays in hotels over 100 nights per year, I was deeply disappointed with my experience here.