I can definitely vouch for the 2 or 4 narrative, those have always been my favorites of the 'Modernish' civ games, but my favorite will always be CivNet (Civ 1 with multiplayer). There is some real simplicity in Civ 1 that makes it much better suited to a multiplayer experience than the later entries. It is a real pain to get any non-hotseat multiplayer working nowawdays, but well-worth it.
I love civ 1 so so much.
Agree, wish there were quality of life improvements to Civ1 that kept the simplicity and aesthetics fully intact, while modernizing some of the tedious mid/late game stuff like managing each city in a large empire based on some straightforward goals like 'more science' or 'fastest path to rocketry' or whatnot.
Freeciv unfortunately has none of the charm of Civ1.