I saw Pink Floyd in '94 at Sun Devil Stadium in Tempe, AZ. One of the largest production rich shows I've ever seen. The sheer magnitude had me in awe.
Best sounding concert I ever heard was Steely Dan circa 1997. The audio was superb, and it was an outdoor venue to boot. A very close second are the Eagles. Their vocal harmonies are nearly perfect, amazing for live.
Most excited and trembling with anticipation factor: Reunited Van Halen, June of this year on opening night in North Carolina. Great to see them together again.
I saw Metallica with Guns and Roses in 1991 (I think it was '91). In between sets, all of the women were flashing the cameras... for almost two hours. That has to rank up there.
One of my favorites was Harry Connick Jr. I was never a fan, in fact my wife drug me there. I'm still not a fan of that genre, but HCJR is probably the single best entertainer I've ever seen. His interaction with the audience and obvious talent in so many arenas will always stick out in my mind.
Energy... has to be Rob Zombie. Wow, what an energy packed performance. What a rush.