It might be helpful, to those giving advice, to have an idea what mindset you have; then we could comment on how that mindset might be useful or... 'not so much'.
It would also be helpful to know what difficulty level you're playing as advice can be very level pertinent and the best (most empathetic) advice will usually come from people playing the same or one level higher than you.
Different people are likely to find inspiration and "ah-ha" moments from different sources. I found Sisiutil's Strategy Guide for Beginners (which could easily be titled "...for Advanced Beginners") very helpful.
https://forums.civfanatics.com/threads/sisiutils-strategy-guide-for-beginners.165632/
Another eye-opening ("ah-ha") source, for me; regarding early game micromanaging and whipping (sacrificing population to hurry production), was Sulla's "Civilization IV Babylon: Always War" YouTube vids.
While I don't micro(manage) nearly as much as he did, I learned to manage my cities much better than before seeing the vids (I don't use the mods that help decide such things). The other thing I learned, from Sulla's YouTube CivIV videos, is to get into the habit of checking my Demographics frequently. Doing so helped give me an idea of where I was, vis a vis the other civs, and helped me allocate my focus from (ie) building a military vs (ie) research vs (ie) food. So, if I don't have any particular plan, the Demographics screen helped me to, at least, give me something in particular to achieve until I formulate a plan.
Just one warning about War Academy articles: there's a lot of hyperbole and a complete misuse of the word "synergy" (CivIV has nearly none...I think I found one or two). The appropriate word might be "complimentary" (in most cases). So, as you read something hyperbolic ("boat loads", "pumping out gazillions"), that sounds absolutely fantastic, it's not really what happens (most of the time) and isn't the "must have/do" thing so don't worry about getting that strategy perfected...just know it exists and could be useful when other strategies aren't.
Some times I start a game and I'm not particularly focused on the relationship between # of turns it takes to do something and the impact of doing it. This most often happens when I'm in a CAESAR (1992) / SIM CITY mindset and I'm not paying enough attention to the other civs. For example, during such moods, I might tend to strive to have both a Barracks and Granary before whipping Axemen and Chariots though they're usually best used earlier than one can get three cities with barracks and granaries. In such a mood, I tend to do it anyway in the hopes "this time I'll get lucky and it'll work out"....it usually doesn't. If I can't shake that mindset, and really want a "builder game", I drop down a difficulty level (or two) and indulge myself.