Studies suggest that, played right, hosting large sporting events can pay lasting noneconomic dividends. But it needs sustained effort.