How much do you use automation of cities, workers, specialists, etc.?
Never, never, sometimes, etc.
Also, in your cities, are you very selective of what buildings get built? I have found that I tend to try to build every building in every city I can and I think I'm missing the boat on how to do this best. I'm new to civ (probably obvious) and find myself getting "lost" in the mid to late game. Suggestions?? thanks!!
When playing on difficulties below King, you can build whatever you want wherever you want with pretty much no thought. Starting at Prince, you should definitely adopt selective building practices -- else maintenance will bury you.
For the most part, the only buildings you should want in every city are Monument, Temple
(optional when playing as France, imo), Library & Market. If you have the money to rushbuy a Workshop, do that first -- otherwise I tend to skip it, since the lifelong savings usually don't add up.
As with many previous CIV editions (esp cIV), you want a core of specialized cities. Depending on the land, I usually have a Core3 (Science, Gold, Military Production) or a Core5 (Core3 + Wonders, Gold) with all associated applicable buildings. Every other city gets the basics plus happiness buildings.
NOTE: Because of the lack of production, I tend not to build happiness buildings in my core cities until vital -- simply because there are more important things to be doing (building specialist buildings, working commerce tiles, being specialists, etc).