First off, there are many great hotels in Bahrain. Most offer clean rooms and attentive staff. This hotel hits those marks, but also provides a great location. It provides decently in-house priced restaurants. If you are trying to watch a soccer match, the in-house sports bar Champs is the place.
Im going to Bahrain for business and planning to get sum1 or 2 along with me.. When I was there last year I stayed at a Hotel with mainly Philipino staff, and Philipino girls who say in the Bar, and that place was apparantly a notorious brothel, but by western standards was very respectable. No offnce is intended towards Philipino women in Bahrain, but in my experience, their presence in a bar seemed to indicate an element of vice. It's worth considering the "Thai" massage parlours in Manama, where privacy, safety and discression appear on offer.