I’m still relatively new to this, and have only seen 28 shows - 24 Broadway National Tours and 4 on Broadway, and in 9 different theaters.
My first preference is always front row balcony, or in the case of some theaters, the mezzanine, or whatever the first elevated level is called that’s over the orchestra section. Only three times have I sat in the orchestra section: once was front row; another time was three rows back; and the worst was farthest on the side, house right. I was lucky and all three occasions worked out well enough.
Even when I’ve had seats that weren’t front row balcony, I’ll try to get an aisle seat that affords the best direct view of the stage. Because some aisles have more seats than the ones in front of them, like the Connor Palace in Cleveland, this worked brilliantly and the view was completely unobstructed.
And for my upcoming season tickets in Pittsburgh I have an end row seat just off center, however they are five rows back in the first tier section of the balcony.
Now, for some shows, sitting as close to the stage as possible is much more important. As in the case of “The Band’s Visit”, everyone recommended getting a seat so close that it allowed you to see the smallest nuances and tiniest expressions in the faces of the actors. That’s were I sat front row orchestra. The disadvantage was that the height of the stage at the Barrymore Theater chopped off the cast at the ankles, and in some cases mid-shin, depending on where there were standing, if you were seated in the front row. And when I saw “My Fair Lady” at the Lincoln Center, the balcony section was curved deeply to the point it put you just far enough away from the stage that small binoculars would have really helped. Even when sitting in the balcony front row.
Keep in mind too that sight lines from seats in the far house left, or house right, even in the balconies, will obstruct or block your view if the action takes place deeper in the stage or on the sides. This was the case for “The Lion King” at the Hippodrome in Baltimore, where platformed sound structures on either side of the stage blocked a couple of scenes that happened on the far side middle section of the stage. And for “Hamilton” several scenes occur on the far sides and deep in the stage. Because of the way the set is designed, if you have a seat on the far sides you will miss some of the action.
And some theaters have support columns, like the Academy of Music in Philadelphia. There are seats marked on the seating chart as obstructed, even if they are in the center sections of the balcony and mezzanines.
One thing I’ve found very helpful is to compare seating charts to actual photographs online of the theater. Even a website like A View From My Seat is very helpful in visualizing what each theater offers. This helps a lot in determining if the extra seats in the row on a websites seating chart actually extend out far enough, or even exist.