Don Valley Stadium was a great venue for Athletics. The only problems were that Athletics rarely attracts full houses and there aren't enough top ranking athletes to justify holding events week in, week out.
As for using the stadium to host football or rugby meant having the pitch so far from the stand that it was difficult to watch at that distance. Chuck in that behind the goad fans would be even further from the action and it was a non starter. I think there was a plan for Sheffield United to move to Don Valley, but the club turned it down.
The only covered seats were in the main stand, with the rest uncovered.
From what i remember the only space for a TV gantry was at the finish line, so it would hardly have been suitable for TV coverage of ball games