In the US teams are replacing 90K seat stadiums with 50 to 60k stadiums. The upkeep and amount of people needed for massive stadiums is not profitable and the parking and traffic after a game is paralyzing. The profits today are TV revenue. Also the local blackout of the game if the stadium does not fill angers local fans.
Keep it small/medium