What the Olympics and other mega-events have shown is that the significant investment required to host an international games successfully has the power to transform a region, and even a nation.