One aspect of this situation that is not contemplated enough is a supposedly historically inspired design idea expressed by civ devs many, many years ago that (roughly speaking) "later ages in civ6 are going to be more peaceful than earlier ones, because this is how it worked in history".
Yeah because it's not how over the course of last 200 years we had Napoleonic wars, Latin American wars, American Civil War, Prussian unification wars, Italian wars, Spanish civil wars, anti Russian uprisings, colonial conquest of the entire world by European powers, scramble for Africa, anti colonial uprisings, Crimean war, Balkan wars, Caucasian wars, Taiping rebellion, 40 years of constant civil wars in 20th century China, Japanese - Russian war, Japanese - Chinese wars, First World War, Russian Civil War, Winter War, Spanish Civil War, Italo Ethiopian War, more wars in Latin America, Second World War, nuclear threat of barely contained Cold War, Korean War, Israeli - Arab wars, Vietnam War, Indo - Pakistani wars, Indochina war, Iraq - Iran War, Yugoslavian wars, 40 years of Afghan wars, Azeri - Armenian wars, Chechen Wars, terrorism, Iraqi war, Syrian civil war, Kurdish conflict, two Algerian wars, Yemeni wars, Bangladesh liberation war, Ethiopian wars, Sudanese civil wars, Sahel wars, Congo wars, Angolan civil war, Mozambican civil war, Myanmar 70 - year long ethnic conflict, oh and Russian invasion of Ukraine in the year 2022.
As you can see, maybe the idea of pacifist later eras is horrible for endgame gameplay, as it makes it even more boring than it already is for fifty other reasons (pointlessly prolonged by fantasy future era etc), but it simply had to be done - historical accuracy is of paramount importance in Civilization games, at all cost, as exemplified by every other historically accurate mechsnic of civ6.
The complete nonexistence of world wars, ideological conflicts/cold wars (like in cvi5: Liberty/liberalism vs Equality/communism vs Fraternity/nationalism) is one of the most bizarre failures of civ6 design - I'd think this is obviously very interesting, spectacular endgame content for everybody, both very casual reddit meme players and civ fanatics, but here we are. Civ5 did ideological clash both for military and pacifist mechanics and largely for this reason I found this game's endgame to be WAY more interesting than civ6.