Off the top of my head, one of the best I've been to would have to be Black Sabbath at Aylesbury Civic Centre (Ozzfest warm up gig). Original lineup and only about 1000 people in the audience. I actually cried halfway through the set I was so happy.