I just saw Foo Fighters in the nosebleeds in a stadium. Great show and was a three-hour set and got my money's worth.
To be honest though, everytime I go to a "big show", i'm a bit let down. Doesn't matter how big the band is. You are way up with thousands of strangers, drinking $40 beer and swiping your credit card all night for drinks and booze.
My favorite shows are in small venues and such a fun experience. Everytime i go to a metal show in a small venue, i meet people, talk about bands and tours and have so much fun. It is a great experience and a lot of these shows are really cheap. I saw Yngwie with Glenn Hughes opening as well as two other bands and I think it was like $30. I've seen shows with six bands for $25.
I won't pay big money to see these shows. It is just absurd to me. For me it is quality over quantity and an experience.