We spent 2 nights here and the location was perfect as I like to walk a lot when I'm traveling. It was really easy to get around union square from here. We were minutes away from the cable car and other public transportation too if you want explore other neighborhoods like North Beach, etc.
The rooms were clean and the staff was pretty nice, but that shouldn't matter too much right? You won't be spending much time in your room anyway!