Well, I am station in Bahrain. I been here since January (right at the beginning of the Arab uprise... sweet memories), and I can say, it is very nice here. You can live anywhere for decent rent and everything here is negotiable. Bahrain is U.S. - friendly and the threat against westerns is low to moderate low. I can go on, but if you want to know more, reply back to me.
As for people looking at you strange or going to bars....not true. Most bars are full of Brits and Americans, but you have to be careful of the Kuwaiti and Saudi guys who comes here to party on the weekend. They DO NOT abide by the Bahrain's laws...as well as driving.
I was here in 2006-2007, and the place change dramatically. New Marriott's hotels chains, western businesses are flourishing. They just screwed themselves out of the F1 racing.
I went lots of places (including bars) by myself in Bahrain, and I didn't have any problems, but I was there in, um, 1980, so I didn't know if things had changed or not. The British were all over the place, especially "the Gulf Air girls."