Some really nice indoor clubs in Dubai are Paus Club and 700 Padel.
It's very subjective though, for me, I want good well maintained indoor courts and hiiiigh ceilings. A club can look pretty and have a great cafe and stuff but if the ceiling is low or court condition is poor I avoid playing there.
There are some nice outdoor clubs in Dubai too, but in summer it is way too hot all hours of the day or night.
Many clubs have other facilities like Yoga and Pilates studios which is gives them a nice mix of people and vibe but I wouldn't care either way.
