Probably the most spectacular concerts I've seen, and by 'spectacular' I mean the effort that went into the stage effects to create an experience that went well beyond the music were these six:
Pink Floyd in 93? with their intense laser show
Bowies 84 Serious Moonlight and the 87 Glass Spider Tour
Michael Jackson's Aussie Tour in 87
ACDC - BallBreaker Tour in 96
KISS - 1980
There's been plenty of 'big' concerts here, particularly in the 80's, but I wasn't much into Bon Jovi, Duran Duran and friends.
Sadly I think the days of these solo gala concerts were numbered a while ago as tour costs can often outweigh profits and the big bands have toned down their stage expenses some what. I remember reading that Bowie made nothing from 'Serious Moonlight' and has kept it a lot simpler since to at least take some profits from touring.
It was bloody exciting to see a band roll into town with 30 semi trailers or Michael Jackson flying into town with cargo planes so big that they blocked out the sun for 5 minutes!
These days I'm just as happy to sit in a 20 seat room and listen to someone play a guitar well