Well, I'll answer my own query since no-one else seems to have the answer.
this is what I did to get all variants and all but the Captain Sim base Legendary C-130 liveries on FS9.
I installed the Just Fligt C-130 from the DVD. Which gives me the in-flight refueling. I then took all of the Captain Sim C-130 expansion packs I have and installed them.
DO NOT INSTALL THE CAPTAIN SIM Legendary C-130 BASE PACK.
That will erase all of the variants that Just Flight has, which is pretty much all of what CS Legendary C-130 base pack has and then some.

Hope this information was helpful to anyone else having the same issue