Agree there are drawbacks to each area. How they will impact you depends on the show and personal preference.
So stalls are closest, which is great if you want to really feel at the centre of what's going on. But you're looking up and you don't get a feel of the full spectacle view. Also if it's all on one level, a tall person in front of you stops you from seeing everything. The back of the stalls in some theatres has an overhang from the circle above which can impede your view.
Dress circle you get a good full view, are looking downwards so maybe more comfortable. But you're a bit distant from the stage so it's less immersive, plus the safety rail is in your line of vision if there is one. Seating is usually on a slope though so you've less chance of someone blocking your vision.
Upper circle you're further away, again you get the good overview and the benefit of the slope, even less immersive. Generally a lot cheaper though and once the show's on if it's a good one you won't care about being further away. Seating can be cramped here in older theatres though.
Anything round at the sides in dress or upper circle, you'll be looking at the stage side on. At the very edges you might lose a bit of the stage. How much that matters depends on the show: most use mostly the middle so you're not really missing much.
Then there's pillars. If you're slap bang behind one you'll see a lot less, even a few rows back from it. Although you can get lucky: if you book restricted view right next to regular seating, when there's empty seats people will shift up and you can get a better seat.
Also you can be cheeky and note if there's empty seats with a good view and just move to them in the interval!