A problem I have is that I have 2+ million images in various folders in lightroom and need to search all the meta data fields for certain words, at the moment I search in the text field each word to find the images I need then I put them in a folder of their own.
I would like to be able to search all words or terms in one go rather than each individually and the script then finds images with these in and move the images to a separate folder, where I can then check those images.
Turning metadata text into folders seems problematical, in the sense that if you come up with rules that a photo ought to be in two (or more) folders, then Lightroom cannot accomodate this. If that is your situation, I would not advise trying to turn this into some sort of folder organization.
But as stated, I don't think Lightroom can do this without writing some sort of plug-in (and even there I doubt it is possible because of the above)