Lots of people are nostalgic for Final Fantasy 7, for example, but I think most prefer the remake over the original.
Early 2D games have the same issue. I think very few people are fans of the Atari 2600 and its extremely crude graphics. To me, that machine is more interesting from the technical perspective than the visual or gameplay perspective.
Remade in 3d, then remade again in 2d to appeal to nostalgia for that style.
I was playing Civ6. And honestly, why the 3D and all the animations? It’s just slow and consumes power that it doesn’t need to. The Civ2, MOO2, MOM, X-Com era is still to my mind the best. I just want the quality of life improvements and some of the newer mechanics from the new games.
I am a huge fan of Civ2, MOO2, MOM, SMACX, and X-Com as well. Bringing those games forward with updated 2D designs, clean user interfaces, and high quality of life would be incredible!
That aside, I broadly agree that 3D graphics in 4X strategy games is, at best, a useless distraction. And sometimes it's actually harmful when it results in fewer noticeable details.
https://www.youtube.com/watch?v=fmHc_o9uoUI
(and then, of course, even if the graphics isn't great, the game mechanics might be so good that the graphics doesn't really matter)