Sir Francis Drake is a block or two up the hill from Union Square and has a trolley car line right in front of the hotel. When I was last in SF, they still had a doorman in costume. It's a fun but somewhat quirky historic hotel and could be a lot of fun.