What are the best hotels to stay in when visiting Bordeaux, taking into account factors such as location, comfort, amenities, service quality, and value for money, and how do these top options compare for different types of travelers (e.g., luxury, mid‑range, or budget)?