Welcome,
It sounds like you want to use Opus for some of the same things I use Opus for. I work with photos and videos mostly.
I use the built-in renaming feature and it is very customizable. I also move files a lot and always need to preserve folder structure. There is no scripting needed for that.
I also add and edit metadata. Feel free to message me privately and tell me more about your needs. Maybe I'll be able to help.
check out this video: Video & Article - Using Directory Opus for Photo Organization