My order of awesomeness, of the stadiums I've been to:
Fenway
New Yankee Stadium - Most of the concourse looks like either a museum or a 5 star hotel... Give them credit.
Oakland Coliseum - Rays vs A's in 2010, walked up to the gate got seats behind the A's bullpen down LF line, everyone was nice
Progressive Field - Nobody was there on a warm April evening in 2008 to see the Sox win 3-0, but the tour took us through the clubhouse and onto the field on a game day
Old Yankee Stadium - Don't remember much, but seemed overrated