For me, the Pyramids are one of the most valuable wonders in the game. They don't always get top priority from the start, because it is not essential to have them in a certain city, like Colossus.. and to a lesser extent HG... are. Whoever builds them (if I can't) will expect a visit from a Diplomat (if they are not in a capital), or an invasion if they are in an AI capital. I will have them, and I will not wait until endgame. It costs too darned much to start rushing Granaries in new cities, and I am certainly not going to let cities grow past size one without the line... starting about 1 AD or so.
I know there are a lot of ways to play the game, but I never worry about getting unhappiness with growth.... I worry about not growing FAST enough. I can never grow too fast. It is impossible to grow too fast. Fast growth means more resurces, and if people don't already know, the idea is to take what you got, and figure the fastest way to get a good return on it. Pyramids are one of the best ways to do that.
Like anything, there is no one, single, magic secret. When you have to, let the AI build the Pyramids, and then go get them. Do not pass up the Colossus, though. The Hanging Gardens are nice, but few people really take advantage of what they can do for you (early Republic). The power of HG is in ICS or ER... and ER is helped by MC. If you are able to get Col+HG in one city, you will usually have to let the Pyramids slide... but if you use the Col+HG right, the result will fund the expedition to get the Pyramids later.
Food is the most difficult thing to make in Civ 2. But if you got it, you can convert it to gold or science by micromanagement. However, the key is to get that reserve to begin with. You will win either way, but If you are not in a Celebrating Republic, you'd better buy granaries (have a strong economy!) or get the Pyramids... if you wanna get powerful quick.
