Hotels in San Francisco, Geneva, and Milan are some of the most expensive places for visitors to spend the night.