This is so interesting that there is such diversity among Civ2 players. I have only recently been made aware of a tactic that I don't think has been mentioned in this thread. I love wine on a hill. But the secret is to mine it! Then you get, the food, the money, the production, the whole enchilada. And if you can slip in a road/railroad, wow!
I also like desert oil that's been irrigated and roaded. Pretty potent and it holds its own for food.