We've been at Uluru back in the early 1980's when it's been raining and it is a sight to see. Back then though the road in was dirt and you could get stranded.
In 1987, we were on our first trip outback. Stayed at Curtin Springs and drove into Uluru. It rained overnight and when we got there, we couldn't see the rock at all. Went into the cafe and had a pie and whilst we were eating it, the clouds parted and there was the rock. Stunning. Off we went and climbed it. Nearly at the top and the clouds came back. Naturally, got drenched. Got back to the car eventually (our daughter kept getting blown off her feet by the winds, and I had to stand downwind of her with my wife upwind). Heater on full and after a while we dried out. Back to Curtin Springs. Next morning, it was still raining at Curtin Springs so we started back towards Alice, but I checked in the mirror and saw absolutely blue sky behind us. U turn and right into Uluru.
The sky was blue, the rock red and there was water cascading from every nook and cranny. Spectacular was not an adequate word. We went out to the Olgas for the day and they were even better. So in that trip, we saw huge contrasts in the nature of the rock. Been back a few times since, but nothing as good as that.