If I visited SF again I'd go to the same place. SF is a big city, but Union Square is a great place to stay as you can easily go anywhere from there.
The place was nice too, and the price was very good as SF is extremely expensive.
The only problem I noticed was that the mattress was not super comfortable, but it was fine.