I've been to about half a dozen Major League stadiums in my life and Chase Field is far and away my favorite. Naturally I'm biased since I'm a true Arizonan and have been a fan of the Diamondbacks ever since the announcement that we were getting a team in the state.
I've been to Chase Field for numerous baseball games, political rallies, religious events and concerts and I've sat everywhere from the very top row to right behind the dugout and I must say there is not a bad seat in the house. I've been to the playgrounds behind center field and on the upper level and I've been cut off at the bar under the seats behind home plate (not my proudest moment) so overall I have a pretty good feel for this park.
Sure concessions can be pricey and the face value on really good tickets can be expensive but if you know what you are doing, the whole trip can be a good value. Buy your water and peanuts from the vendors on the street and take them inside with you , but remember not to open them before you enter.
For tickets, scalping is legal if they are across the street from the plaza, so check the scalpers and feel free to shop around. When the D-Backs aren't playing well (like this year) you should be able to get a pair of tickets for less than the face value of one. Heck, even in 2001 when they won the World Series you could almost always get tickets at face value or even a slight discount.
The ballpark has a wide variety of concessions and even offers a value menu of food items for just $1.50.
When its 110-degrees outside and you want a few hours out of the heat there's no better alternative than visiting Chase Field and remember to root root root for the D-Backs, because if they don't win it's a shame.