Only times it has been outdoors is in Florida and California. WM 35 was outdoors at MetLife, but much like the NFL they made a "cold weather" exemption because its New York. & now Philly in 2 years, which will be interesting. Conceivably there is nothing stopping them from having it at Nissan Stadium but the easiest way to get one is with a new/world class venue.
Turner Field was also only like 20 years old when the Braves replaced it.
Likewise with the Texas Rangers, they only stayed 25 years in Arlington before decamping (tho it was in order to move into a retractable roof venue)
I think the indoor ones for hockey/basketball will last longer. Smaller venue at 18K capacity. So, long as the size is there, they can add whatever is in vogue, like bars/restaurants and other things. Vancouver is in tough because it was built between 2 viaducts so the concourse is more narrow.
Boston, StL, Philly all had 9 figure renovations done to their arenas that opened in the 90's. Same with the Suns that opened in 1992. Plus all of the others in LA, chicago, anaheim, montreal, etc. should just need renovations. Also because there would likely be transit near that facility, the location works.
The ones where the interior is exposed to the elements, that's tougher, but you do expect renovations to it. Just a sad state to see stadiums that are like 25-30 years old needing to be replaced. Like the baseball ones that you pointed it, it's kind of crazy that Turner Field replace Fulton County Stadium in the 90's and then itself got replaced a few years ago.