Very few stadiums with a decent capacity are located in nice areas. Good neighbourhoods tend not to be supportive of the development of a large concrete structure that is likely to lead to traffic congestion and parking issues every week. Some of the stadiums listed above are in decent areas but events there are so poorly attended they would lead to no greater parking issues than your average Saturday vigil mass.
We are talking about “shithole” areas. There is a world of difference from a Celtic Park, Stade de France or Thomond Park and some US example like Cowboys Stadium, which is located in a grand spot but outside of Dallas. Mac asserted that most stadiums are in shitholes, he doesn’t have a clue.