If you can afford it and your more concerned about the view then I would go Upper Doug or Middle/Upper Trinity as close to the Half way line that you can......You should avoid people standing up for no apparent reason
How dare you haha, I've had many great moments in the trinity middle , saw my 1st game there over 30 yrs ago and apart from a handful of games it's where I've always sat , best for view in my opinion ,but not for atmosphere.
Just dont go Trinity Middle, bunch of moaning old gits there.