Tranquil rooms, a buzzy restaurant and a prime location on the Embarcadero set this San Francisco hotel apart.