We went in November and was in GA. Amazing U2 concert and the Sphere show just enhanced everything. I do think the 200-300 level would be the best spot.It's up to you, of course. Bono is like 60 years old so he's not running around during Streets like he used to. Also, odd that there was no Disqoteche or anything from Pop or Zooropa as those songs seem to want this technology. The first half of the show was way more "immersive" with the screen than the second half.
I bought tickets at face value in the 300s and about $500 for GA, and they are differente experience but i think 100 or 200 center is your best bet for a single show. Truthfully, I'm a little shy to tell you to go or not because if you don't like it I don't want to be held responsible!
as for the set list, do I wish they had played a few older songs, sure, but I wasn't dissappointed In the least.
I don't profess to being the biggest U2 fan (5 shows?), but of the hundreds of live shows I've seen, this was Top 5.