IOI's probably right to reconsider the publishing business. Its not often that a game is truly, blatantly going to be an obvious failure when it hits the market, but MindsEye really was that bad the entire way through its dev cycle, and IOI fucked up massively giving it so much benefit of the doubt over that life cycle.
As for Civ 7, I have no idea what went wrong in their core dev process, but they completely lost the plot, it reeks of "we tried changing the design because we can, but we don't understand what players actually play our games for". They tried to 'fix' the problem of players being done with saves before the final end screen by just constantly soft resetting the game state, which just prevented players from ever reaching a comfortable quit situation - so they only had uncomfortable ones instead, no wonder the sentiment tanked. A player saying "I've gotten what I wanted out of this run, no need to bully the AI into letting me conquer every tile of the map, lets start a new game" is not a failure state, its a success because they've played out an entire path of how a game could go, and still want to jump back in and try another.
No matter how large the Firaxis layoffs were, they weren't large enough. Axe them all and call Civ7 a squib game, cut your losses and start early on Civ8. Maybe look back at the older games and reintroduce some systemic complexity now that player resources, UX/UI design and other prior constraints have advanced significantly to allow complexity to be more palletable. 4X games are struggling in competition with Grand Strategies and RTS games right now - Not that any of them are mass market kings, but while RTS is seeing a minor resurgence as players rediscover the fun of short match gameplay, and Grand Strategies are continuing to grow as they take advantage of newer UX concepts to increase their depth without obfuscating things, 4X is stuck trying to keep individual systems simple, and make up for it with a volume of systems. But wide as an ocean, shallow as a puddle, usually makes everyone unhappy. 4X's space should be in its ability for players to end up playing each game significantly differently to take advantage of inconsistent starting opportunities, and Civ is not making use of this at all right now.