I still play civilization 2.42.
Unfortunately, it is a 16 bit game that only runs on a disappearing 32 bit windows.
I keep a pc just for this purpose.
Of the others, Civ IV is good, V is beautiful, but 6 is dumbed down graphics.
Not sure on patch 2.42, but I have gotten Civilization II to run off my Civ II disk in Windows 7 64bit. It was about 18 months ago though so not clear on how I did it, but it took me about 30 minutes or so to find a thread somewhere on how to do it.