We had a great stay - it was incredibly convenient, being in the heart of SF.
The only downside was that it could be noisy at times (the tram car goes right by the window, and it could be a tad loud).