I believe your 2nd example is exactly what I'm looking for!
Just to confirm, if I want to (theoretically) split folder names alphabetically with each letter going to its own separate HDD, I should set up rules as so:
\TV-Shows\A*\* ---> HDD-01
\TV-Shows\B*\* ---> HDD-02
\TV-Shows\C*\* ---> HDD-03
and so on until....
\TV-Shows\Z*\* ---> HDD-26
Sorry, just wanted to make sure before I make a significant change Thank you very much for the help!