Sheffield built the Don Valley Stadium fir the World Student games. It never found a subsequent use despite hosting rugby league, football, etc. It has been demolished.
Edinburgh built Meadowbank for the 1970 Commonwealth Games. It was used for football and other sports. The only time is ever was properly used for for the 1986 Commonwealth Games. It was largely demolished recently and replaced by a much smaller facility.
Glasgow declined to build a stadium for the 2014 Commonwealth Games and instead adapted Hampden Park by putting in a false floor to fit a track around the playing area. It was removed after the games.
A massive athletics stadium was always going to fail and Seb Coe’s vision would certainly have flopped even in the scaled down form. Multi-purpose arenas often fail unless the design is very good and satisfy no one.
The current London Stadium certainly is a mess.