Yeah, the computer makes bizarre production choices if you aren’t paying attention. (“Longbowman? WTF, it’s 2020AD!”) This is even if you “contact governor” and adjust build priorities. I tend to zoom to the city and queue up half a dozen or more things at a time to deal with it.
I agree. Lately, I’ve had good success by establishing as many cities as I possibly can as quickly as I can. My early priority is not to build improvements; it’s to spread myself out across the landscape as much as possible. This accomplishes two things: First, I secure monopolies on resources (or at least don’t get shut out by another civ’s monopoly), and second, I start building the Forbidden City in a distant location as soon as I can. This makes a huge difference in productivity later.
I agree the game has some flaws. The railroads are ridiculously powerful, but on the other hand the helicopters are totally useless (as someone above mentioned). The dialogue for the other leaders uses too much modern vernacular, too; it’s distracting when Julius Caesar says something like the equivalent of “blow me,” or whatever. Better writing would have helped a lot.
One other thing I don’t much like is how the civs are all focused on defeating me rather than each advancing itself, which means they sometimes behave collectively in ways that make no sense. It’s frustrating, for example, when other leaders jump down my throat for encroaching on their borders, and yet I see Roman units cheerfully traipsing through French territory without causing international incidents.
Oh, and the documentation is pretty iffy. They don’t tell you, for example, that once you’re finished building the final spaceship component, the game is over. You can’t choose to delay launching it for whatever reason; when you’re done, you’re done. (The victory movie here is pretty cool, though.) Similarly, once you finish the United Nations, you almost immediately go to an election for the Secretary General: If you win, you win the game, but if you lose, the game is over, period. You can’t suffer a diplomatic failure and then continue to pursue a military victory, or whatever. The documentation doesn’t warn you about this. And there are a lot of other little things in gameplay that I couldn’t find at all in the book or in the Civilopedia that I ended up having to work out through trial and error.
But I’m nitpicking, really. I loves me this game. I have to be careful about how much time I spend on it lest I annoy my wife with my absence. 
P.S. Did you know you can find the .WAV files for the various unit sounds in the program directory? If you’ve got a sound editor or even just a microphone, it’s pretty easy to make the Marines yell “Boo-yah, motherfucker!” when they win. 