Afaik, there is no magical rename tool that I've seen as yet unfortunately, especially something that uses the metadata from the mods themselves, because a sizeable chunk of them have no internal metadata at all or totally unknown.
I decided years ago to rename the mods, ie. author_modname.extension, here on MA they use something similar. I only chose it this way to make it easier for me to structure the mods, so I could keep an Excel list of everything as a database and store the mods on my system.
I use TotalCommander for most stuff, it does have a multi-rename tool function that can make renaming the file name easier and batch rename too, there are probably other utils that do the same thing out there.
I seem to remember a mod renamer program on Modland. There are some utilities in the pub/software/utilities/dos or windows folders. I think it renames to the internal title of the mod and also batch rename all files (that it supports), but it won't rename by author etc.
You could also try Saga' Mod Library from his website, doesn't rename files or anything but does generate a good database of your mod collection.