Most of Dubai is pretty cheesy. That said, at least you can usually find a cold beer in one of the hotels.
That being said, Dubai used to be a great place to spend a few days. Great hotels, restaurants and some good shopping. Way better than Bahrain. For night clubs I used to go to the Irish Village on the backside of the tennis stadium, the Rock Bottom Cafe.
This is where I used to stay. The hotel was only one room thick so every room had a water view. Incredible pools and the nicest gym I've ever been in.