It very much depends on the capacity of the venue. I've had great views and horrible views.
The M.E.N in Manchester is 18,000 to 20,000 and you get a really good view from anywhere (although I've never sat right at the back it seems it would still be more than acceptable). Larger than that can be a problem from further back.
What capacity is Foxwoods? About 8,000? If so I don't think you'll have any issues (unless you happen to find a pillar directly in front of you!).