Overall, a fine experience, but with caveats
We recently stayed four nights at The Inn at the Opera on Fulton Street in San Francisco. It's a tiny hotel, about two rooms wide, but in a terrific location for any doings at City Hall, the Opera, or a symphony or ballet performance.
The staff is absolutely first rate, with a genuinely friendly and immediately helpful approach to each guest. They park your car for you and bring it back quickly, when needed. We couldn't try the restaurant, because it's being renovated, but the late afternoon cookies were yummy, and a nice buffet breakfast was provided in the lobby.
Rooms are well-equipped but small, and closet space is at a premium. A long stay would probably cause cabin fever, and there's just one small and slow elevator. Also, the neighborhood is a mixed bag, definitely not a place to wander around after dark.