From the Hilton to comfortable business hotels and budget-friendly guest houses: our ranked guide to the best places to stay