I think that Wembley has to be in the top three of famous stadium worldwide. Wembley is known for hosting other public spectacles, whereas purpose-built stadiums like Old Trafford are only known for football and diving. Amongst football fans however, there are arguably more "famous" or well-known arenas. Anfield, Olympiastadion and San Siro, at least for semi-old farts like me. I doubt that many non-football fans outside their respective countries can name stadiums like Bernabéu, Bombonera or even the Maracanã. Hell, for being publicly known you could even argue that Hillsborough and Heysel are more "famous" than those, at least for those with a functioning memory. Good points on the above mentioned cross-overs like Yankee Stadium, who was featured prominently on shows like Seinfeld. I've also heard Wrigley Field mentioned in more movies than I can recall. For boxing fans, Madison Square Garden has to be the most famous. For the younger generation, who knows.
That said, I really would like for us to incorporate White Hart Lane in some capacity at the new stadium. For all the British' aptitude for naming things something cool, many of your football stadiums have sort of, well, less than common names. Like Potato Field, Cowshed Stadium, The Outhouse, The Pigs' Pen, Highbury and such. White Hart Lane on the other hand, is a name that expresses something elegant, something genuinely British, royal almost. I can quite objectively say that it's the most beautiful name for a stadium anywhere. Every stadium loses some of it's soul when the corporization of the sport goes too deep. Who the hell can love an Emirates, JJB or Duncan's Radio Repair Stadium? I know that it's a business, but I don't have to have it rammed down my throat. At least the Americans call it what it has become, a franchise.