They do. As did the old White Hart Lane, St James Park etc. Thing about atmosphere is that it's not really appreciable on a YouTube video filmed from someone's mobile 'phone, and something you have to experience in person by being there. Emirates, Etihad, Stamford Bridge, Wembley - not so much.
Liverpool, although I can't stand them, will have an amazing / intimidating atmosphere for the Roma match (depending on your allegiance).
Admittedly, those German stadiums are
bouncing. Literally. They look great.
P.S. @
Enron. A Liverpool fan that isn't an delusioned and entitled whinger. Seems like a good lad.