Revisiting this thread years later, now that I've learned more about what makes music tick.
One of the main "secrets" (I put the word in quotation marks because it isn't particularly obscure knowledge) I've found--and I don't recall anyone mentioning this here--is the fact that chord progressions sound best when the chord roots progress rather than regress. Progress means: move up a second or down a third or up a perfect fourth or any inversion of the aforementioned motions. Doing this creates an impression that the music is moving forward rather than rowing against the current. It's surprising to me no one mentioned this, because it's fairly common knowledge among music theorists and, even when not spelled out by them, can be inferred by looking at a typical map of "allowed" chord progressions.
Another piece of advice I've discovered for myself is to be very careful with what chord inversions you use in succession. The ear keeps track of where the root of each chord is positioned, and changing inversion can therefore create an impression of an awkward leap even when the voices appear to move smoothly. As such, it isn't a bad idea to ensure that the chord roots proceed in a melodious fashion.
One idea I reject is that minimizing the distance the voices move creates a more pleasant effect. By that logic, you may as well not move the voices at all for the entirety of a composition. Another piece of advice I reject is that keeping a common tone in one voice leads to a better effect than doing the opposite. The musical literature is rife with examples where the common tone is taken up by a different voice while the one that carried the tone moves up or down. Generally, it sounds fine.
One thing that sounds definitely bad is, of course, placing tones within a critical band of each other. This usually happens when composers put major or minor thirds down in the bass range. The effect is commonly referred to as muddy, and for good reason.
Other than that, I can't think of any particularly great advice for writing good chord progressions that isn't common knowledge to anyone who has studied counterpoint and harmony very extensively. If anyone has some further thoughts on the subject, though, I would love to hear them.