Hosting the Olympic Games was once a symbol of prestige. Today, rising costs and environmental concerns raise a critical question: is it still worth it?