What you're talking about using is Powershell, which is a full featured object oriented scripting language and yes it can be complicated and also mostly used by IT professionals to automate tasks.
Get-ChildItem cmdlet is what you would grab all files that you wanted to examine.
With all the files saved in an array you would then need to loop through them all and then very specifically determine which use case applies (probably with regex) and then transform the filename (string) and call Rename-Item