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.