Originally Posted by: wingman23as a beginner it dont half confuse the heck out of you...
:-)

I believe that's the purpose of it. Just to confuse and annoy - For the most part anyway :P
Though there is "some" logic to it from what little I know, as it can extend the range of notes available to you - ie drop D tuning allows you to play 2 extra semi-tones below the low E you'd usually play.
Drop C confuses me, sure dropping to the C gives you further range, but why screw up the other 5 strings? I can only assume it's somehow to compensate for the huge change on your bottom E but generally I just straight up avoid songs that require me to change my tuning. Drop D I can deal with, I can quickly tune the bottom E to a D by ear with no hassle - everything else I just avoid. Seems like being different for the sake of being different.