Hotel Drisco, Waters Edge, Inn at Union Square, and Club Donatello are the top hotel options in San Francisco.