I've stayed at dozens of SF hotels in my life... and IMHO this one had got to have the best location for Wharf-are fun!
This hotel puts you one block from Ghirardelli, two blocks from the Cannery centers; depending on your room, may give you screaming view of the Bay with Alcatraz at center; and sits you right next to the Hyde Cable Car line. You will have a balcony and furniture from which to take all this in, too.
The property is a bit sterile, and lacks charm (let's add some splashes of color and flowers, SAFW!). I get the sense that many of the rooms are corporate apartments or long-term leases. Thus there isn't that hustle-bustle of a "real" hotel.
However, it does have spacious, clean, comfortable updated rooms which can't be beat for families and/or long stays. Our kitchen was new, well-equiped and sparkling clean. You will be very comfortable. We felt quite at home even though our stay was short (this time!).
The service was nice, too.
Be warned: the rooms on the eastern end (#s 100, 200, and 300) truly hear the running cable and cable cars all day, starting at 6 a.m. Atmospheric!?