I think the best pit I have been in would be the Cradle of Filth gig in Wolverhampton a few years back, people flying everywhere.
But the best gig I ever went to with the best atmosphere was deffo Nightwish, all of em hehe.