I haven't really been to a lot of concerts, but the one that sticks out the most was probably Pantera and White Zombie about 10 years ago. I saw them in a small theatre in Reno and they were both at their best.
A couple of years ago I went to see James Taylor in an outdoor arena. It rained and thundered and it was still a lot of fun.