The best visual show I went to was an Alice Cooper concert in 2001.
The best musical concert was watching Roger Waters perform The Wall in it's entirety in 2010.

I've seen a lot of really awesome concerts but those two took the top.