I would recommend the Sir Francis Drake, especially since you’re doing a touristy trip. The hotel is steeped in SF history and definitely “feels” very SF. A cable car line passes right by the front entrance.
The standard room is small, but nothing too unusual. Think standard for NYC hotels. The “Grand” category is a large room and many of the Grand 2 Queens are very big.
Status recognition is average, but an upgrade to a grand room for Spire should be possible.