So basically all of the China Olympics and Qatar WC stadia?? Not being snarky, just confirming that I understand you correctly.
Yeah, those are good examples. They all look somewhat different and distinctive, but the features that make them visually distinctive don't cost all that much in the grand scheme of things
what do you think of the Tottenham Hotspur soccer stadium in North London (both aesthetically and in terms of cost relative to other modern stadia)?
FWIW, I haven't been in person, and don't know anything about the cost that isn't in the public domain. My impression is that a big driver of cost was the whole three-section retractable grass pitch. I mean: it's super-cool to pull off something that's never been done before-- like a natural grass football pitch that divides into three sections, each of which retracts to reveal an artificial field underneath-- especially if you have a blank check to create it. So, fun project. And worth the price if price is no object.
Big public projects like this have a lot of stakeholders who tend to want and appreciate different things. So, I'm guessing that the main stakeholders (the team owners) are happy with the design and execution, because that's going to be super important to the design/build teams. Which is to say, it kinda doesn't matter what I think. Or rather: what I think isn't evidence of whether the design/build teams did their jobs well, or not.
That said-- since you asked an honest question-- my answer would be: the new stadium is.... fine?
My impression is that it's comfortable, clean, snazzy/modern in all the ways a stadium can be snazzy and modern. I've heard people say "there isn't a bad seat in the house" which is the kind of thing that with modern computer imaging/design software should be true of every stadium built everywhere, unless someone really messed up. But that doesn't lessen that people appreciate it, and the design/build team should get credit for getting that right. So high level, there's nothing about the place to criticize, as far as I can tell. It's a fine stadium
That said-- and this is my own thing & I wasn't the client-- I really appreciate it when a big public project like that tries to really clearly make itself "of" the place where it's going to be. I like it when there's something that makes you say "this could only be here" or maybe "this is the kind of thing that should really really be in this place". This example is a bit dated and a bit of a cliché, but think of when they built Camden Yards in the early 90s and very intentionally minimized the right field seating so that the old B&O warehouse would loom over right field, and everyone who came to home plate would try to hit it with a home run. When you're in that ballpark there's no ambiguity that you're anywhere in the world but the old part of Baltimore's inner harbor.
Again, I haven't been... but when people are in the new Spurs stadium do they have a feeling like that? Or could they be in any modern stadium anywhere in the world? Put another way: does the stadium feel like a natural part of the neighborhood, or like it was dropped down from outer space? (Aside: I don't know 'cause I don't know much about the situation, but to some world-travelling, sports-team-owner billionaires being big and expensive and not 'of' a run-down, blue-collar neighborhood in north London might be a feature, not a bug. Mileage, variance, and all that.)
One image to look at in the context of the last few paragraphs.
Here's another photo that gets at this. (Aside: in the first photograph I like what they did with the scale/color/texture of the 2-3 story buildings on the street in the bottom right of that photo. They're modern and different, but feel much more like they make sense next to the other stuff on the block. I'd have liked to see the rest of the stadium try more of something similar).
I've heard some Spurs fans say that it's been several years since the place opened and it doesn't feel like "home" the way the former place did. Now different people are going to react to new stuff differently, and some of this will change with time. But I don't remember Orioles fans going to Camden in the early days and being nostalgic for the old Orioles stadium. Their experience was more like the reverse.
That's closer to what I would have tried to achieve for Spurs fans. Although, and I know I'm repeating myself, but I wasn't the client. Billionaires gonna build what billionaires want to build.
Fake edit/coming back to add: My impression is that big part of the new stadium is that it comfortably seats (all with great views of the pitch) something like ~25-30K more people, and also has 4x the amount of indoor square footage for restaurants, bars, and other amenities. And those things are big deals and add a lot to the fan experience. So both should be counted on the side of the ledger for 'design/build team came up with something good'