I use to be there as stopover when I go to Hong Kong for example. I suggest 2 o 3 days. Never in boreal summer. It's a nice place, safe and with tons of things to do.
Sky Dubai is great. People is cool, you wont have any problem there, just respect the rules and have common sense.
https://www.tripadvisor.com.ar/Attra..._of_Dubai.html