I reverse this ... I tell LR exactly where to look for the photos upon "import". File management is my task, along with the Finder, not for LR to mess with. When the time comes, I point LR to the location of the files I want it to import, and keep my files organized the way I want. 🙂Different rendering platforms have different advantages and disadvantages. LR is the same as all the others in this regard.
However, LR does tell you exactly where your photos are located.
But I treat batches of DNGs as if they were rolls of film (which is how it all started decades ago), with appropriate numbering, each batch in a separate folder, and numbered to correspond with a FileMaker database containing subject and tech data for each batch.
Anyway, there may be a couple of operations on a new batch before LR is allowed to see them... First I name the folder with the batch number. Then I use A Better Finder Rename to rename and sequence the DNGs in the folder according to the folder name. Additionally I may also correct the EXIF lens info with ExifChanger.
This is just how I've been doing it, and I'm open to new ideas from discussions like this. I share for the possible interest of others... 🙂