Is the World Cup a Solid Investment for a Country?

The most recent country to host has built a city and its costs $220 billion US or the equivalent. How does that recoup money for you? I guess by having other big events, that's one of the only ways to do it. The last cup in 2018 in Russia, those were sold to broadcasters around the world for billions of dollars.