The expression 'soccer mecca' for me implies not just the 'temple' but especially the city (&/or the footballistic environment) in which it was erected. So, historically: Wembley/London Stade Olympique de Colombes/Paris Centenário/Montevidéo Maracanã/Rio de Janeiro Oympic Stadium/Rome San Siro/Milan Estádio da Luz/Lisbon Estádio Azteca/Ciudad de Mexico Olympiastadion/München Monumental de Nuñez/Buenos Aires Stade de France/Paris Olympiastadion/Berlin
Problem with this is they aren't all soccer stadia per se. Many were built for other events, primarily Olympic Games. But Stade de France? Surely you jest. It was built 15 years ago and is in some nondescript northern banlieu. Other than the 2006 World Cup final and a few German cup finals were any meaningful games played in Berlin's Olympiastadion?
The municipality of Paris is actually Central Paris only, it's a really small area in size. What you describe as "some nondescript northern banlieue" would be the East river area in Brooklyn or the Queens in NYC. Furthermore, the Stade de France is located near Saint-Denis basilica, which is the place where the French kings are buried. It's not the random place you pretended it was.
The Strahov isn't a football stadium. It's a parade ground with terraces around it. It's big enough to hold 9 pitches (3 by 3), but the stadium part of it is very ordinary.
Well, it took a little while (fine, a long while), but here we are with number two! http://soccer-source.blogspot.com/2012/09/ranking-worlds-soccer-meccas-no-2.html
What a load of nonsense! Hardly any qualify!! Try. Galatasaray, Fenerbache, Boca Juniors, Rio Plate, Celtic, Rangers!
Rosario, Argentina. I have yet to live a classico like the Newells vs Central games. Incredible. No wonder the greatest player of all time is from there. The way that city becomes consumed, then explodes is incredible. That is the most passionate derby. Nobody can convince me otherwise. I have witnessed this phenomenon first hand.