The Civ 6 wonder animations were impressive in some ways, but didn’t make my games much more enjoyable or immersive. Don’t get me wrong, the game was better for including them, but they didn’t add that much for me.
By far, the best wonder visualizations I have seen are the ones in Civ 2. And one of the reasons why they worked so well, was that they took you away from the map, and showed you a different way to view the world you were building. They were good reminders that you weren’t just filling out squares and filling up buckets, but that everything that happened in the game was part of a real world. Which of course is an illusion, but wanting to believe in such illusions is part of why we play electronic games.
There is a philosophy of game design where it is thought that the more you can show on the main map, the better. And the way wonders were executed in Civ 6 seems to be aligned with this philosophy. But sometimes pulling you away from the main map you see most of the time has advantages too, that you end up losing if you eliminate that completely.
After the ones in Civ 2, I think I liked the ones in Civ 5 the most. They were just splash screens with music and quotes, but the effect was often very enjoyable. My favorite game, Civ 3, had the worst ones. Given their limited budget at the time, it probably wasn’t a bad idea to make cuts there, but it felt a little lacking.