My wife and I stayed at The Orchard in mid-late May 2015. We were upgraded from a king room to a king suite. Didn't think we'd use the additional space but it actually was nice to have the second room and (tv) when we wanted to call it an early night and I wanted to watch the Warriors game instead of the E! network.
The location is great for public transportation. It's right on the cable car route and you can get a spot easily if you are up before 8:30, I think they start at 6. These can be pretty loud on the street but we did not have an issue with the cable car noise in our room or any other noise. Great access to other areas like the Wharf and financial district as well. Lots of good food and drinks in the area, one of our favorites was the Hogwash, which is just down the road, for good beer and food. Bartenders were more than happy to give us other tips on food/beer/coffee (other than Starbucks).