Chord progressions are based on theory and therefore won't change with tuning. What you need are chord shapes, which are specific to the guitar, and have only changed because you changed the tuning. If you're only changing the sixth string to drop D, then all 5th string root chords are unchanged and all 6th string root chords require you to play 2 frets higher on the 6th string.
C major (5th string root) will still be: 0 1 0 2 3 X
F major (6th string root) will be:
1 1 2 3 3 3
You really only gain two things from a drop D tuning. One is access to those two lower notes, the Eb and D. The other is an easier shape for power chords (xxx333 vs xx331).
GT/PSN: Owngineer Currently playing: Rocksmith, Resident Evil 6, Resident Evil