We visited the Dubai fountains at the end of our first day - we were tired, hungry and our feet were hurting. And yet, what joy it brought to us - the music, the dancing fountains, the light and colour! Absolutely worth it!
Tips: This is just outside Dubai mall, and can be visited on the way back from Burj Khalifa.
2. I guess its most beautiful in the evenings, with the light and all.
3. You don't have to stress about standing in the front, or at viewing from a higher place. We could see the fountains absolutely fine from the ground floor, somewhere at the back.